{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","Group 1","Base Calc","Lowrise Indoor Water Use","Lowrise Wastewater Use","Summary D+C","Summary O+M","Summary ND"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":25,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":63,"n_cols":22,"rows_kept":63,"cut":false,"hidden":false,"merged":[[5,4,5,10],[2,4,2,10],[10,4,10,10],[6,4,6,10],[37,4,37,10],[32,4,32,10],[30,4,30,10],[9,4,9,9],[17,4,17,10],[22,4,22,10],[25,4,25,10],[26,4,26,10],[27,4,27,10],[19,4,19,10],[18,4,18,10],[13,4,13,9],[14,4,14,10],[48,2,48,5],[49,2,49,5],[50,2,50,5],[51,2,51,5],[36,4,36,10],[52,2,52,5],[47,2,47,5],[42,12,42,16],[42,6,42,9],[43,6,43,7],[43,8,43,9],[42,10,43,10],[42,2,43,5],[44,2,44,5],[45,2,45,5],[46,2,46,5]]}
[]
[]
[null,null,null,null,"Indoor Water Use Reduction Calculator\nLEED v4 and v4.1 for D+C and v4 for O+M - WE Prerequisite/Credit Indoor Water Use Reduction \nLEED v4 for ND - GIB Prerequisite/Credit Indoor Water Use Reduction and GIB Credit Wastewater Management"]
[]
[null,null,null,null,"Step 1. "]
[null,null,null,null,"Enable macros."]
[null,null,null,null,"Note: This calculator is for use with Excel for Mac 2011 and Excel 2007 or later.  If you are experiencing a problem with this calculator, please refer to the help center instructions below."]
[null,null,null,null,"Help Center Instructions"]
[null,null,null,null,"Step 2. "]
[null,null,null,null,"Unit of measurement",null,null,null,null,null,"IP units"]
[null,null,null,null,"Note: This selection must match the unit of measurement chosen during project registration."]
[]
[null,null,null,null,"Step 3. "]
[null,null,null,null,"The project is LEED for Neighborhood Development",null,null,null,null,null,"No"]
[null,null,null,null,"Note: This selection must match the rating system chosen during project registration."]
[]
[null,null,null,null,"Step 4. "]
[null,null,null,null,"For projects pursuing GIB Prerequisite/Credit Indoor Water Use Reduction"]
[null,null,null,null,"Nonresidential, mixed-use, and multifamily residential buildings four stories or more\nComplete the Flush and/or Flow tables on the Group tab(s) for all new/major renovations nonresidential, mixed-use, and multifamily residential buildings four stories or more."]
[null,null,null,null,"Note: If actual occupancy is not known, use the default (residents = number of bedrooms + 1) for each dwelling unit.  All residential units can be included in one group."]
[]
[]
[null,null,null,null,"Single-family residential and multiunit residential buildings three stories or fewer\nComplete the Lowrise Indoor Water Use tab for all new single-family residential and multiunit residential buildings three stories or fewer."]
[]
[null,null,null,null,"Step 5. "]
[null,null,null,null,"For projects pursuing GIB Credit Wastewater Management"]
[null,null,null,null,"Complete the Lowrise Wastewater Use tab for all new single-family residential and multiunit residential buildings three stories or more."]
[null,null,null,null,"Note: The calculations performed for GIB Prerequisite/Credit Indoor Water Use Reduction are sufficient for documenting nonresidential, mixed-use, and multifamily residential buildings four stories or more."]
[]
[null,null,null,null,"Step 4."]
[null,null,null,null,"Complete the Flush and/or Flow tables on the Group tab."]
[]
[null,null,null,null,"Note: Projects with extremely complex occupancy and/or fixture usage patterns (such as where different types of occupants have different annual days of operation and use fixtures with differing flush and flow rates within the building) may complete a separate calculator tab to represent the usage for complex scenarios. "]
[]
[]
[null,null,null,null,{"$f":"IF(NDrs = 1,\"Step 6.\",\"Step 5.\")","v":"Step 5."}]
[null,null,null,null,"Upload the completed spreadsheet to LEED Online.  Complete any related summary fields in the LEED credit form with the results of the calculator."]
[null,null,null,null,"Note: Include in the prerequisite calculations all fixtures within the LEED project boundary.  Include in the credit calculations all fixtures and fittings necessary to meet the needs of the occupants; some of these fittings and fixtures may be outside the tenant space (for Commercial Interiors) or project boundary (for New Construction).  Upload a separate calculator for the credit as necessary."]
[]
[]
[]
[null,null,"Assumptions"]
[null,null,"Fixture Type",null,null,null,"Maximum Installed Flush/Flow Rate",null,null,null,"Duration\n(sec)",null,"Default Uses per Day"]
[null,null,null,null,null,null,"IP",null,"SI",null,null,null,"Employees\n(FTE)","Visitors","Retail Customers","Students\n(K-12)","Residential"]
[null,null,"Toilet (male)",null,null,null,1.6,"gpf",6,"lpf","n/a",null,1,0.1,0.1,1,5]
[null,null,"Toilet (female)",null,null,null,1.6,"gpf",6,"lpf","n/a",null,3,0.5,0.2,3,5]
[null,null,"Urinal",null,null,null,1,"gpf",3.8,"lpf","n/a",null,2,0.4,0.1,2,0]
[null,null,"Public lavatory (restroom) faucet",null,null,null,0.5,"gpm",1.9,"lpm",30,null,3,0.5,0.2,3,0]
[null,null,"Private (residential) lavatory faucet",null,null,null,2.2000000000000002,"gpm",8.3000000000000007,"lpm",60,null,0,0,0,0,5]
[null,null,"Kitchen faucet",null,null,null,2.2000000000000002,"gpm",8.3000000000000007,"lpm",15,null,1,0,0,0,0]
[null,null,"Residential kitchen faucet",null,null,null,2.2000000000000002,"gpm",8.3000000000000007,"lpm",60,null,0,0,0,0,4]
[null,null,"Showerhead",null,null,null,2.5,"gpm",9.5,"lpm",300,null,0.1,0,0,0,0]
[null,null,"Residential showerhead",null,null,null,2.5,"gpm",9.5,"lpm",480,null,0,0,0,0,1]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V05.1",null,"UOM",null,"RS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copyright © 2012",null,{"$f":"IF(K10=\"IP units\",1,2)","v":1},"1 = IP, 2 = SI",{"$f":"IF(K14=\"Yes\",1,2)","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U.S. Green Building Council",null,null,null,"ND = 1, nonND =2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All Rights Reserved",null,null,"Toilet","Urinal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Last Updated 08/18/2022",null,"Toilet","Conventional Water Closet","Conventional Urinal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urinal","Low-Flow Water Closet","Low-Flow Urinal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dual-Flush Water Closet","Non-Water Urinal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Composting Toilet"]

{"sheet":"Group 1","index":1,"n_rows":50,"n_cols":33,"rows_kept":50,"cut":false,"hidden":false,"merged":[[32,3,32,5],[4,1,4,2],[6,1,6,9],[7,1,7,10],[8,1,8,10],[9,1,9,2],[14,1,14,10],[27,1,27,9],[28,8,29,8],[29,3,29,5],[30,3,30,5],[31,3,31,5],[44,2,44,3],[45,2,45,3],[46,2,46,3],[47,2,47,3],[33,3,33,5],[34,3,34,5],[40,1,40,10],[41,8,42,8],[42,2,42,3],[43,2,43,3]]}
[]
[null,{"$f":"REPLACE(CELL(\"filename\",A1),1,FIND(\"]\",CELL(\"filename\",A1)),\"\")","v":"Group 1"}]
[]
[]
[null,"Group name",null,"Group 1"]
[null,"Table: Project Information"]
[null,"Enter project occupancy information.  This information should be consistent with occupancy numbers used in other LEED credits. "]
[null,"Non-default gender mix\nThe default gender mix is half male and half female.  If necessary, modify the Male and Female occupant type columns for non-default gender mix if the project is specifically designed for an alternative gender ratio or the project is expected to have alternative gender usage rates for the life of the building.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non-default gender mix",false]
[null,"The project includes ADA and/or gender-neutral bathrooms          \nIf the project includes separate gender neutral and/or ADA restrooms without urinals, the LEED default assumption is that 5% of male occupants and 5% of female occupants use these restrooms. Enter 95% into the percent of males expected to use restrooms with urinals below. Alternately, the project team can estimate this percentage based on the project's restroom layout/anticipated usage patterns or weighted fixture counts.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non-default gender mix",true]
[null,"Occupancy Type",null,"Employees\n (FTE)","Visitors","Retail Customers","Students\n(K-12)","Residential","Other (specify)",null,"Gender \nRatio\n(%)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nondefault values"]
[null,"Total",null,null,null,null,null,null,null,null,{"$f":"SUM(K12:K13)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Baseline","Flow",{"$f":"I49","v":0},null,{"$f":"AB12+AB13","v":0},0,0,0,0,0]
[null,"Male",null,{"$f":"IF(ISODD(D$11)=TRUE,INT(D$11/2)+1,D$11/2)","v":0},0,0,0,0,0,null,{"$f":"IFERROR(SUM($D$12:$I$12) / SUM(Total2),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Baseline","Flush",{"$f":"I36","v":0}]
[null,"Female",null,{"$f":"INT(D$11/2)","v":0},0,0,0,0,0,null,{"$f":"IFERROR(SUM($D$13:$I$13)/SUM(Total2),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Design","Flow",{"$f":"I50","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Design","Flush",{"$f":"I37","v":0},null,"Default values"]
[null,"Determine the percent of males expected to use urinals (enter 100% if all male restrooms have urinals, 0% if the project contains no urinals, etc)"]
[null,"Percent of males expected to use restrooms with urinals ",null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISODD(AB$11)=TRUE,INT(AB$11/2)+1,AB$11/2)","v":0},0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INT(AB$11/2)","v":0},0,0,0,0,0]
[null,"Enter the number of days the project is accessible to employees or FTE."]
[null,"Annual days of operation ",null,null,null,null,null,null,365]
[null,{"$f":"IF(I19>365,\"Annual days of operation must be between 1 and 365.\",\"\")","v":""}]
[null,"For projects with dual-flush toilets"]
[null,"Enter the resulting flush rate into the design case flush rate section below."]
[null,{"$f":"CONCATENATE(\"Low flush \",IF(Instructions!$T$57=1,\"(gpf)\",\"(lpf)\"))","v":"Low flush (gpf)"}]
[null,{"$f":"CONCATENATE(\"Full flush \",IF(Instructions!$T$57=1,\"(gpf)\",\"(lpf)\"))","v":"Full flush (gpf)"}]
[null,{"$f":"CONCATENATE(\"LEED weighted average flush rate \",IF(Instructions!$T$57=1,\"(gpf)\",\"(lpf)\"))","v":"LEED weighted average flush rate (gpf)"},null,null,{"$f":"IFERROR(((K12*E23* (2-(I16*2)) )+(K13*2*E23)+(K12*E24)+(K13*E24))/((K12*(1+ (2-(I16*2)) )+(K13*(1+2)))),0)","v":0}]
[]
[null,"Table: Flush Fixtures"]
[null,"1. Indicate the Fixture ID that matches the information provided in the plumbing schedule.\n2. Select the Fixture Family and Fixture Type installed on the project.\n3. Enter the Design Flush Rate identified by the manufacturer - for dual flush toilets, use the dual flush calculator to determine average flush rate.\n4. Enter Percent of Occupants with access to the fixture. If the fixture is installed in all restrooms, use 100%. \n5. If necessary, modify the Total Uses per Day column for non-default uses."]
[null,"Fixture Information",null,null,null,null,"Flush Rate",null,"Percent of Occupants\n(%)",null,"Uses per Day",null,null,null,null,null,null,"Total Daily Uses",null,null,"Total Daily Water Use"]
[null,"Fixture \nID","Fixture Family","Fixture Type",null,null,{"$f":"CONCATENATE(\"Baseline \nFlush Rate\",IF(Instructions!T57=1,\"\n(gpf)\",\"\n(lpf)\"))","v":"Baseline \nFlush Rate\n(gpf)"},{"$f":"CONCATENATE(\"Design \nFlush Rate\",IF(Instructions!T57=1,\"\n(gpf)\",\"\n(lpf)\"))","v":"Design \nFlush Rate\n(gpf)"},null,null,"Employees\n(FTE)","Visitors","Retail Customers","Students\n(K-12)","Residential",{"$f":"IF($I$10=\"Other (specify)\",\"Other\",$I$10)","v":"Other"},null,"Default","Non-default\n(Optional)",null,{"$f":"CONCATENATE(\"Baseline\n\",IF(Instructions!$T$57=1,\"(gallons)\",\"(liters)\"))","v":"Baseline\n(gallons)"},{"$f":"CONCATENATE(\"Design \n\",IF(Instructions!$T$57=1,\"(gallons)\",\"(liters)\"))","v":"Design \n(gallons)"},null,"Helper column"]
[{"$f":"IF(B31>0,0,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(IF(Instructions!$T$57=1,VLOOKUP(C31,Instructions!$C$45:$J$47,5,TRUE),VLOOKUP(C31,Instructions!$C$45:$J$47,7,TRUE)),\"\")","v":""},null,null,null,{"$f":"IF($D$11>0,IF($C31=\"Toilet (male)\",1+(2*(1-$I$16)),IF($C31=\"Toilet (female)\",Instructions!$M$46,IF($C31=\"Urinal\",2*$I$16,0))),0)","v":0},{"$f":"IF($E$11>0,IF($C31=\"Toilet (male)\",0.1+(0.4*(1-$I$16)),IF($C31=\"Toilet (female)\",Instructions!$N$46,IF($C31=\"Urinal\",0.4*$I$16,0))),0)","v":0},{"$f":"IF($F$11>0,IF($C31=\"Toilet (male)\",0.1+(0.1*(1-$I$16)),IF($C31=\"Toilet (female)\",Instructions!$O$46,IF($C31=\"Urinal\",0.1*$I$16,0))),0)","v":0},{"$f":"IF($G$11>0,IF($C31=\"Toilet (male)\",1+(2*(1-$I$16)),IF($C31=\"Toilet (female)\",Instructions!$P$46,IF($C31=\"Urinal\",2*$I$16,0))),0)","v":0},{"$f":"IF($H$11>0,IF($C31=\"Toilet (male)\",Instructions!$Q$45,IF($C31=\"Toilet (female)\",Instructions!$Q$46,IF($C31=\"Urinal\",Instructions!$Q$47,0))),0)","v":0},null,null,{"$f":"IFERROR(IF(C31=\"Toilet (female)\",(($D$13*K31)+($E$13*L31)+($F$13*M31)+($G$13*N31)+($H$13*O31)+($I$13*P31)),(($D$12*K31)+($E$12*L31)+($F$12*M31)+($G$12*N31)+($H$12*O31)+($I$12*P31))),0)","v":0},null,null,{"$f":"IFERROR(IF($S31>0,G31*(S31*(I31/100)),G31*(R31*(I31/100))),0)","v":0},{"$f":"IFERROR(IF($S31>0,H31*(S31*(I31/100)),H31*(R31*(I31/100))),0)","v":0},null,{"$f":"IF(OR(C31=\"Toilet (male)\",C31=\"Toilet (female)\"),\"Toilet\",IF(C31=\"Urinal\",\"Urinal\",\"\"))","v":""}]
[{"$f":"IF(B32>0,0,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(IF(Instructions!$T$57=1,VLOOKUP(C32,Instructions!$C$45:$J$47,5,TRUE),VLOOKUP(C32,Instructions!$C$45:$J$47,7,TRUE)),\"\")","v":""},null,null,null,{"$f":"IF($D$11>0,IF($C32=\"Toilet (male)\",1+(2*(1-$I$16)),IF($C32=\"Toilet (female)\",Instructions!$M$46,IF($C32=\"Urinal\",2*$I$16,0))),0)","v":0},{"$f":"IF($E$11>0,IF($C32=\"Toilet (male)\",0.1+(0.4*(1-$I$16)),IF($C32=\"Toilet (female)\",Instructions!$N$46,IF($C32=\"Urinal\",0.4*$I$16,0))),0)","v":0},{"$f":"IF($F$11>0,IF($C32=\"Toilet (male)\",0.1+(0.1*(1-$I$16)),IF($C32=\"Toilet (female)\",Instructions!$O$46,IF($C32=\"Urinal\",0.1*$I$16,0))),0)","v":0},{"$f":"IF($G$11>0,IF($C32=\"Toilet (male)\",1+(2*(1-$I$16)),IF($C32=\"Toilet (female)\",Instructions!$P$46,IF($C32=\"Urinal\",2*$I$16,0))),0)","v":0},{"$f":"IF($H$11>0,IF($C32=\"Toilet (male)\",Instructions!$Q$45,IF($C32=\"Toilet (female)\",Instructions!$Q$46,IF($C32=\"Urinal\",Instructions!$Q$47,0))),0)","v":0},null,null,{"$f":"IFERROR(IF(C32=\"Toilet (female)\",(($D$13*K32)+($E$13*L32)+($F$13*M32)+($G$13*N32)+($H$13*O32)+($I$13*P32)),(($D$12*K32)+($E$12*L32)+($F$12*M32)+($G$12*N32)+($H$12*O32)+($I$12*P32))),0)","v":0},null,null,{"$f":"IFERROR(IF($S32>0,G32*(S32*(I32/100)),G32*(R32*(I32/100))),0)","v":0},{"$f":"IFERROR(IF($S32>0,H32*(S32*(I32/100)),H32*(R32*(I32/100))),0)","v":0},null,{"$f":"IF(OR(C32=\"Toilet (male)\",C32=\"Toilet (female)\"),\"Toilet\",IF(C32=\"Urinal\",\"Urinal\",\"\"))","v":""}]
[{"$f":"IF(B33>0,0,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(IF(Instructions!$T$57=1,VLOOKUP(C33,Instructions!$C$45:$J$47,5,TRUE),VLOOKUP(C33,Instructions!$C$45:$J$47,7,TRUE)),\"\")","v":""},null,null,null,{"$f":"IF($D$11>0,IF($C33=\"Toilet (male)\",1+(2*(1-$I$16)),IF($C33=\"Toilet (female)\",Instructions!$M$46,IF($C33=\"Urinal\",2*$I$16,0))),0)","v":0},{"$f":"IF($E$11>0,IF($C33=\"Toilet (male)\",0.1+(0.4*(1-$I$16)),IF($C33=\"Toilet (female)\",Instructions!$N$46,IF($C33=\"Urinal\",0.4*$I$16,0))),0)","v":0},{"$f":"IF($F$11>0,IF($C33=\"Toilet (male)\",0.1+(0.1*(1-$I$16)),IF($C33=\"Toilet (female)\",Instructions!$O$46,IF($C33=\"Urinal\",0.1*$I$16,0))),0)","v":0},{"$f":"IF($G$11>0,IF($C33=\"Toilet (male)\",1+(2*(1-$I$16)),IF($C33=\"Toilet (female)\",Instructions!$P$46,IF($C33=\"Urinal\",2*$I$16,0))),0)","v":0},{"$f":"IF($H$11>0,IF($C33=\"Toilet (male)\",Instructions!$Q$45,IF($C33=\"Toilet (female)\",Instructions!$Q$46,IF($C33=\"Urinal\",Instructions!$Q$47,0))),0)","v":0},null,null,{"$f":"IFERROR(IF(C33=\"Toilet (female)\",(($D$13*K33)+($E$13*L33)+($F$13*M33)+($G$13*N33)+($H$13*O33)+($I$13*P33)),(($D$12*K33)+($E$12*L33)+($F$12*M33)+($G$12*N33)+($H$12*O33)+($I$12*P33))),0)","v":0},null,null,{"$f":"IFERROR(IF($S33>0,G33*(S33*(I33/100)),G33*(R33*(I33/100))),0)","v":0},{"$f":"IFERROR(IF($S33>0,H33*(S33*(I33/100)),H33*(R33*(I33/100))),0)","v":0},null,{"$f":"IF(OR(C33=\"Toilet (male)\",C33=\"Toilet (female)\"),\"Toilet\",IF(C33=\"Urinal\",\"Urinal\",\"\"))","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(IF(Instructions!$T$57=1,VLOOKUP(C34,Instructions!$C$45:$J$47,5,TRUE),VLOOKUP(C34,Instructions!$C$45:$J$47,7,TRUE)),\"\")","v":""},null,null,null,{"$f":"IF($D$11>0,IF($C34=\"Toilet (male)\",1+(2*(1-$I$16)),IF($C34=\"Toilet (female)\",Instructions!$M$46,IF($C34=\"Urinal\",2*$I$16,0))),0)","v":0},{"$f":"IF($E$11>0,IF($C34=\"Toilet (male)\",0.1+(0.4*(1-$I$16)),IF($C34=\"Toilet (female)\",Instructions!$N$46,IF($C34=\"Urinal\",0.4*$I$16,0))),0)","v":0},{"$f":"IF($F$11>0,IF($C34=\"Toilet (male)\",0.1+(0.1*(1-$I$16)),IF($C34=\"Toilet (female)\",Instructions!$O$46,IF($C34=\"Urinal\",0.1*$I$16,0))),0)","v":0},{"$f":"IF($G$11>0,IF($C34=\"Toilet (male)\",1+(2*(1-$I$16)),IF($C34=\"Toilet (female)\",Instructions!$P$46,IF($C34=\"Urinal\",2*$I$16,0))),0)","v":0},{"$f":"IF($H$11>0,IF($C34=\"Toilet (male)\",Instructions!$Q$45,IF($C34=\"Toilet (female)\",Instructions!$Q$46,IF($C34=\"Urinal\",Instructions!$Q$47,0))),0)","v":0},null,null,{"$f":"IFERROR(IF(C34=\"Toilet (female)\",(($D$13*K34)+($E$13*L34)+($F$13*M34)+($G$13*N34)+($H$13*O34)+($I$13*P34)),(($D$12*K34)+($E$12*L34)+($F$12*M34)+($G$12*N34)+($H$12*O34)+($I$12*P34))),0)","v":0},null,null,{"$f":"IFERROR(IF($S34>0,G34*(S34*(I34/100)),G34*(R34*(I34/100))),0)","v":0},{"$f":"IFERROR(IF($S34>0,H34*(S34*(I34/100)),H34*(R34*(I34/100))),0)","v":0},null,{"$f":"IF(OR(C34=\"Toilet (male)\",C34=\"Toilet (female)\"),\"Toilet\",IF(C34=\"Urinal\",\"Urinal\",\"\"))","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(IF(Instructions!$T$57=1,VLOOKUP(C35,Instructions!$C$45:$J$47,5,TRUE),VLOOKUP(C35,Instructions!$C$45:$J$47,7,TRUE)),\"\")","v":""},null,null,null,{"$f":"IF($D$11>0,IF($C35=\"Toilet (male)\",1+(2*(1-$I$16)),IF($C35=\"Toilet (female)\",Instructions!$M$46,IF($C35=\"Urinal\",2*$I$16,0))),0)","v":0},{"$f":"IF($E$11>0,IF($C35=\"Toilet (male)\",0.1+(0.4*(1-$I$16)),IF($C35=\"Toilet (female)\",Instructions!$N$46,IF($C35=\"Urinal\",0.4*$I$16,0))),0)","v":0},{"$f":"IF($F$11>0,IF($C35=\"Toilet (male)\",0.1+(0.1*(1-$I$16)),IF($C35=\"Toilet (female)\",Instructions!$O$46,IF($C35=\"Urinal\",0.1*$I$16,0))),0)","v":0},{"$f":"IF($G$11>0,IF($C35=\"Toilet (male)\",1+(2*(1-$I$16)),IF($C35=\"Toilet (female)\",Instructions!$P$46,IF($C35=\"Urinal\",2*$I$16,0))),0)","v":0},{"$f":"IF($H$11>0,IF($C35=\"Toilet (male)\",Instructions!$Q$45,IF($C35=\"Toilet (female)\",Instructions!$Q$46,IF($C35=\"Urinal\",Instructions!$Q$47,0))),0)","v":0},null,null,{"$f":"IFERROR(IF(C35=\"Toilet (female)\",(($D$13*K35)+($E$13*L35)+($F$13*M35)+($G$13*N35)+($H$13*O35)+($I$13*P35)),(($D$12*K35)+($E$12*L35)+($F$12*M35)+($G$12*N35)+($H$12*O35)+($I$12*P35))),0)","v":0},null,null,{"$f":"IFERROR(IF($S35>0,G35*(S35*(I35/100)),G35*(R35*(I35/100))),0)","v":0},{"$f":"IFERROR(IF($S35>0,H35*(S35*(I35/100)),H35*(R35*(I35/100))),0)","v":0},null,{"$f":"IF(OR(C35=\"Toilet (male)\",C35=\"Toilet (female)\"),\"Toilet\",IF(C35=\"Urinal\",\"Urinal\",\"\"))","v":""}]
["A",{"$f":"CONCATENATE(\"Baseline case annual flush volume \",IF(Instructions!$T$57=1,\"(gallons/year)\",\"(liters/year)\"))","v":"Baseline case annual flush volume (gallons/year)"},null,null,null,null,null,null,{"$f":"(SUM(U31:U35)*$I$19)","v":0}]
[null,{"$f":"CONCATENATE(\"Design case annual flush volume \",IF(Instructions!$T$57=1,\"(gallons/year)\",\"(liters/year)\"))","v":"Design case annual flush volume (gallons/year)"},null,null,null,null,null,null,{"$f":"(SUM(V31:V35)*$I$19)","v":0}]
[]
[]
[null,"Table: Flow Fixtures"]
[null,"1. Indicate the Fixture ID that matches the information provided in the plumbing schedule.\n2. Select the Fixture Type installed on the project.\n3. If necessary, modify the Duration column for non-default values.\n4. Enter the Design Flow Rate identified by the manufacturer.\n5. Enter Percent of Occupants with access to the fixture. If the fixture is installed in all restrooms, use 100%.\n6. If necessary, modify the Total Uses per Day column for non-default uses."]
[null,"Fixture Information",null,null,"Duration",null,"Flow Rate",null,"Percent of Occupants\n(%)",null,"Uses per Day",null,null,null,null,null,null,"Total Daily Uses",null,null,"Total Daily Water Use"]
[null,"Fixture \nID","Fixture Type",null,"Default\n(sec)","Non-default\n(sec)\n(Optional)",{"$f":"CONCATENATE(\"Baseline \nFlow Rate\",IF(Instructions!$T$57=1,\"\n(gpm)\",\"\n(lpm)\"))","v":"Baseline \nFlow Rate\n(gpm)"},{"$f":"CONCATENATE(\"Design \nFlow Rate\",IF(Instructions!$T$57=1,\"\n(gpm)\",\"\n(lpm)\"))","v":"Design \nFlow Rate\n(gpm)"},null,null,"Employees\n(FTE)","Visitors","Retail Customers","Students\n(K-12)","Residential",{"$f":"IF($I$10=\"Other (specify)\",\"Other\",$I$10)","v":"Other"},null,"Default","Non-default\n(Optional)",null,{"$f":"CONCATENATE(\"Baseline\n\",IF(Instructions!$T$57=1,\"(gallons)\",\"(liters)\"))","v":"Baseline\n(gallons)"},{"$f":"CONCATENATE(\"Design \n\",IF(Instructions!$T$57=1,\"(gallons)\",\"(liters)\"))","v":"Design \n(gallons)"}]
[{"$f":"IF(B44>0,1,1)","v":1},null,null,null,{"$f":"IFERROR(VLOOKUP(C44,Instructions!$C$45:$K$53,9,FALSE),\"\")","v":""},null,{"$f":"IFERROR(IF(Instructions!$T$57=1,VLOOKUP(C44,Instructions!$C$45:$K$53,5,FALSE),VLOOKUP(C44,Instructions!$C$45:$K$53,7,FALSE)),\"\")","v":""},null,null,null,{"$f":"IF($D$11>0,IFERROR(VLOOKUP($C44,Instructions!$C$45:$Q$53,11,FALSE),0),0)","v":0},{"$f":"IF($E$11>0,IFERROR(VLOOKUP($C44,Instructions!$C$45:$Q$53,12,FALSE),0),0)","v":0},{"$f":"IF($F$11>0,IFERROR(VLOOKUP($C44,Instructions!$C$45:$Q$53,13,FALSE),0),0)","v":0},{"$f":"IF($G$11>0,IFERROR(VLOOKUP($C44,Instructions!$C$45:$Q$53,14,FALSE),0),0)","v":0},{"$f":"IF($H$11>0,IFERROR(VLOOKUP($C44,Instructions!$C$45:$Q$53,15,FALSE),0),0)","v":0},null,null,{"$f":"IFERROR(($D$11*K44)+($E$11*L44)+($F$11*M44)+($G$11*N44)+($H$11*O44)+($I$11*P44),0)","v":0},null,null,{"$f":"IFERROR(IF(S44>0,\n   IF(E44=\"n/a\",G44*(S44*(I44/100))*(60/60),\n       IF(F44>0,G44*(S44*(I44/100))*(F44/60), G44*(S44*(I44/100))*(E44/60))),\n   IF(E44=\"n/a\",G44*(R44*(I44/100))*(60/60),\n       IF(F44<0,G44*(R44*(I44/100))*(F44/60), G44*(R44*(I44/100))*(E44/60)))\n),0)","v":0},{"$f":"IFERROR(IF(S44>0,\n   IF(E44=\"n/a\",H44*(S44*(I44/100))*(60/60),\n       IF(F44>0,H44*(S44*(I44/100))*(F44/60), H44*(S44*(I44/100))*(E44/60))),\n   IF(E44=\"n/a\",H44*(R44*(I44/100))*(60/60),\n       IF(F44>0,H44*(R44*(I44/100))*(F44/60), H44*(R44*(I44/100))*(E44/60)))\n),0)","v":0}]
[{"$f":"IF(B45>0,1,1)","v":1},null,null,null,{"$f":"IFERROR(VLOOKUP(C45,Instructions!$C$45:$K$53,9,FALSE),\"\")","v":""},null,{"$f":"IFERROR(IF(Instructions!$T$57=1,VLOOKUP(C45,Instructions!$C$45:$K$53,5,FALSE),VLOOKUP(C45,Instructions!$C$45:$K$53,7,FALSE)),\"\")","v":""},null,null,null,{"$f":"IF($D$11>0,IFERROR(VLOOKUP($C45,Instructions!$C$45:$Q$53,11,FALSE),0),0)","v":0},{"$f":"IF($E$11>0,IFERROR(VLOOKUP($C45,Instructions!$C$45:$Q$53,12,FALSE),0),0)","v":0},{"$f":"IF($F$11>0,IFERROR(VLOOKUP($C45,Instructions!$C$45:$Q$53,13,FALSE),0),0)","v":0},{"$f":"IF($G$11>0,IFERROR(VLOOKUP($C45,Instructions!$C$45:$Q$53,14,FALSE),0),0)","v":0},{"$f":"IF($H$11>0,IFERROR(VLOOKUP($C45,Instructions!$C$45:$Q$53,15,FALSE),0),0)","v":0},null,null,{"$f":"IFERROR(($D$11*K45)+($E$11*L45)+($F$11*M45)+($G$11*N45)+($H$11*O45)+($I$11*P45),0)","v":0},null,null,{"$f":"IFERROR(IF(S45>0,\n   IF(E45=\"n/a\",G45*(S45*(I45/100))*(60/60),\n       IF(F45>0,G45*(S45*(I45/100))*(F45/60), G45*(S45*(I45/100))*(E45/60))),\n   IF(E45=\"n/a\",G45*(R45*(I45/100))*(60/60),\n       IF(F45<0,G45*(R45*(I45/100))*(F45/60), G45*(R45*(I45/100))*(E45/60)))\n),0)","v":0},{"$f":"IFERROR(IF(S45>0,\n   IF(E45=\"n/a\",H45*(S45*(I45/100))*(60/60),\n       IF(F45>0,H45*(S45*(I45/100))*(F45/60), H45*(S45*(I45/100))*(E45/60))),\n   IF(E45=\"n/a\",H45*(R45*(I45/100))*(60/60),\n       IF(F45>0,H45*(R45*(I45/100))*(F45/60), H45*(R45*(I45/100))*(E45/60)))\n),0)","v":0}]
[{"$f":"IF(B46>0,1,1)","v":1},null,null,null,{"$f":"IFERROR(VLOOKUP(C46,Instructions!$C$45:$K$53,9,FALSE),\"\")","v":""},null,{"$f":"IFERROR(IF(Instructions!$T$57=1,VLOOKUP(C46,Instructions!$C$45:$K$53,5,FALSE),VLOOKUP(C46,Instructions!$C$45:$K$53,7,FALSE)),\"\")","v":""},null,null,null,{"$f":"IF($D$11>0,IFERROR(VLOOKUP($C46,Instructions!$C$45:$Q$53,11,FALSE),0),0)","v":0},{"$f":"IF($E$11>0,IFERROR(VLOOKUP($C46,Instructions!$C$45:$Q$53,12,FALSE),0),0)","v":0},{"$f":"IF($F$11>0,IFERROR(VLOOKUP($C46,Instructions!$C$45:$Q$53,13,FALSE),0),0)","v":0},{"$f":"IF($G$11>0,IFERROR(VLOOKUP($C46,Instructions!$C$45:$Q$53,14,FALSE),0),0)","v":0},{"$f":"IF($H$11>0,IFERROR(VLOOKUP($C46,Instructions!$C$45:$Q$53,15,FALSE),0),0)","v":0},null,null,{"$f":"IFERROR(($D$11*K46)+($E$11*L46)+($F$11*M46)+($G$11*N46)+($H$11*O46)+($I$11*P46),0)","v":0},null,null,{"$f":"IFERROR(IF(S46>0,\n   IF(E46=\"n/a\",G46*(S46*(I46/100))*(60/60),\n       IF(F46>0,G46*(S46*(I46/100))*(F46/60), G46*(S46*(I46/100))*(E46/60))),\n   IF(E46=\"n/a\",G46*(R46*(I46/100))*(60/60),\n       IF(F46<0,G46*(R46*(I46/100))*(F46/60), G46*(R46*(I46/100))*(E46/60)))\n),0)","v":0},{"$f":"IFERROR(IF(S46>0,\n   IF(E46=\"n/a\",H46*(S46*(I46/100))*(60/60),\n       IF(F46>0,H46*(S46*(I46/100))*(F46/60), H46*(S46*(I46/100))*(E46/60))),\n   IF(E46=\"n/a\",H46*(R46*(I46/100))*(60/60),\n       IF(F46>0,H46*(R46*(I46/100))*(F46/60), H46*(R46*(I46/100))*(E46/60)))\n),0)","v":0}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(C47,Instructions!$C$45:$K$53,9,FALSE),\"\")","v":""},null,{"$f":"IFERROR(IF(Instructions!$T$57=1,VLOOKUP(C47,Instructions!$C$45:$K$53,5,FALSE),VLOOKUP(C47,Instructions!$C$45:$K$53,7,FALSE)),\"\")","v":""},null,null,null,{"$f":"IF($D$11>0,IFERROR(VLOOKUP($C47,Instructions!$C$45:$Q$53,11,FALSE),0),0)","v":0},{"$f":"IF($E$11>0,IFERROR(VLOOKUP($C47,Instructions!$C$45:$Q$53,12,FALSE),0),0)","v":0},{"$f":"IF($F$11>0,IFERROR(VLOOKUP($C47,Instructions!$C$45:$Q$53,13,FALSE),0),0)","v":0},{"$f":"IF($G$11>0,IFERROR(VLOOKUP($C47,Instructions!$C$45:$Q$53,14,FALSE),0),0)","v":0},{"$f":"IF($H$11>0,IFERROR(VLOOKUP($C47,Instructions!$C$45:$Q$53,15,FALSE),0),0)","v":0},null,null,{"$f":"IFERROR(($D$11*K47)+($E$11*L47)+($F$11*M47)+($G$11*N47)+($H$11*O47)+($I$11*P47),0)","v":0},null,null,{"$f":"IFERROR(IF(S47>0,\n   IF(E47=\"n/a\",G47*(S47*(I47/100))*(60/60),\n       IF(F47>0,G47*(S47*(I47/100))*(F47/60), G47*(S47*(I47/100))*(E47/60))),\n   IF(E47=\"n/a\",G47*(R47*(I47/100))*(60/60),\n       IF(F47<0,G47*(R47*(I47/100))*(F47/60), G47*(R47*(I47/100))*(E47/60)))\n),0)","v":0},{"$f":"IFERROR(IF(S47>0,\n   IF(E47=\"n/a\",H47*(S47*(I47/100))*(60/60),\n       IF(F47>0,H47*(S47*(I47/100))*(F47/60), H47*(S47*(I47/100))*(E47/60))),\n   IF(E47=\"n/a\",H47*(R47*(I47/100))*(60/60),\n       IF(F47>0,H47*(R47*(I47/100))*(F47/60), H47*(R47*(I47/100))*(E47/60)))\n),0)","v":0}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(C48,Instructions!$C$45:$K$53,9,FALSE),\"\")","v":""},null,{"$f":"IFERROR(IF(Instructions!$T$57=1,VLOOKUP(C48,Instructions!$C$45:$K$53,5,FALSE),VLOOKUP(C48,Instructions!$C$45:$K$53,7,FALSE)),\"\")","v":""},null,null,null,{"$f":"IF($D$11>0,IFERROR(VLOOKUP($C48,Instructions!$C$45:$Q$53,11,FALSE),0),0)","v":0},{"$f":"IF($E$11>0,IFERROR(VLOOKUP($C48,Instructions!$C$45:$Q$53,12,FALSE),0),0)","v":0},{"$f":"IF($F$11>0,IFERROR(VLOOKUP($C48,Instructions!$C$45:$Q$53,13,FALSE),0),0)","v":0},{"$f":"IF($G$11>0,IFERROR(VLOOKUP($C48,Instructions!$C$45:$Q$53,14,FALSE),0),0)","v":0},{"$f":"IF($H$11>0,IFERROR(VLOOKUP($C48,Instructions!$C$45:$Q$53,15,FALSE),0),0)","v":0},null,null,{"$f":"IFERROR(($D$11*K48)+($E$11*L48)+($F$11*M48)+($G$11*N48)+($H$11*O48)+($I$11*P48),0)","v":0},null,null,{"$f":"IFERROR(IF(S48>0,\n   IF(E48=\"n/a\",G48*(S48*(I48/100))*(60/60),\n       IF(F48>0,G48*(S48*(I48/100))*(F48/60), G48*(S48*(I48/100))*(E48/60))),\n   IF(E48=\"n/a\",G48*(R48*(I48/100))*(60/60),\n       IF(F48<0,G48*(R48*(I48/100))*(F48/60), G48*(R48*(I48/100))*(E48/60)))\n),0)","v":0},{"$f":"IFERROR(IF(S48>0,\n   IF(E48=\"n/a\",H48*(S48*(I48/100))*(60/60),\n       IF(F48>0,H48*(S48*(I48/100))*(F48/60), H48*(S48*(I48/100))*(E48/60))),\n   IF(E48=\"n/a\",H48*(R48*(I48/100))*(60/60),\n       IF(F48>0,H48*(R48*(I48/100))*(F48/60), H48*(R48*(I48/100))*(E48/60)))\n),0)","v":0}]
["B",{"$f":"CONCATENATE(\"Baseline case annual flow volume \",IF(Instructions!$T$57=1,\"(gallons/year)\",\"(liters/year)\"))","v":"Baseline case annual flow volume (gallons/year)"},null,null,null,null,null,null,{"$f":"SUM(U44:U48)*$I$19","v":0}]
[null,{"$f":"CONCATENATE(\"Design case annual flow volume \",IF(Instructions!$T$57=1,\"(gallons/year)\",\"(liters/year)\"))","v":"Design case annual flow volume (gallons/year)"},null,null,null,null,null,null,{"$f":"SUM(V44:V48)*$I$19","v":0}]

{"sheet":"Base Calc","index":2,"n_rows":50,"n_cols":33,"rows_kept":50,"cut":false,"hidden":true,"merged":[[47,2,47,3],[29,3,29,5],[30,3,30,5],[31,3,31,5],[32,3,32,5],[33,3,33,5],[34,3,34,5],[40,1,40,10],[42,2,42,3],[43,2,43,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[41,8,42,8],[28,8,29,8],[8,1,8,10],[14,1,14,10],[27,1,27,9],[6,1,6,9],[4,1,4,2],[9,1,9,2],[7,1,7,10]]}
[]
[null,{"$f":"REPLACE(CELL(\"filename\",A1),1,FIND(\"]\",CELL(\"filename\",A1)),\"\")","v":"Base Calc"}]
[]
[]
[null,"Group name",null,{"$f":"B2","v":"Base Calc"}]
[null,"Table: Project Information"]
[null,"Enter project occupancy information.  This information should be consistent with occupancy numbers used in other LEED credits. "]
[null,"Non-default gender mix\nThe default gender mix is half male and half female.  If necessary, modify the Male and Female occupant type columns for non-default gender mix if the project is specifically designed for an alternative gender ratio or the project is expected to have alternative gender usage rates for the life of the building.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non-default gender mix",false]
[null,"The project includes ADA and/or gender-neutral bathrooms          \nIf the project includes separate gender neutral and/or ADA restrooms without urinals, the LEED default assumption is that 5% of male occupants and 5% of female occupants use these restrooms. Enter 95% into the percent of males expected to use restrooms with urinals below. Alternately, the project team can estimate this percentage based on the project's restroom layout/anticipated usage patterns or weighted fixture counts.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non-default gender mix",true]
[null,"Occupancy Type",null,"Employees\n (FTE)","Visitors","Retail Customers","Students\n(K-12)","Residential","Other (specify)",null,"Gender \nRatio\n(%)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nondefault values"]
[null,"Total",null,null,null,null,null,null,null,null,{"$f":"SUM(K12:K13)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Baseline","Flow",{"$f":"I49","v":0},null,{"$f":"AB12+AB13","v":0},0,0,0,0,0]
[null,"Male",null,{"$f":"IF(ISODD(D$11)=TRUE,INT(D$11/2)+1,D$11/2)","v":0},0,0,0,0,0,null,{"$f":"IFERROR(SUM($D$12:$I$12) / SUM(Total2),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Baseline","Flush",{"$f":"I36","v":0}]
[null,"Female",null,{"$f":"INT(D$11/2)","v":0},0,0,0,0,0,null,{"$f":"IFERROR(SUM($D$13:$I$13)/SUM(Total2),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Design","Flow",{"$f":"I50","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Design","Flush",{"$f":"I37","v":0},null,"Default values"]
[null,"Determine the percent of males expected to use urinals (enter 100% if all male restrooms have urinals, 0% if the project contains no urinals, etc)"]
[null,"Percent of males expected to use restrooms with urinals ",null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISODD(AB$11)=TRUE,INT(AB$11/2)+1,AB$11/2)","v":0},0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INT(AB$11/2)","v":0},0,0,0,0,0]
[null,"Enter the number of days the project is accessible to employees or FTE."]
[null,"Annual days of operation ",null,null,null,null,null,null,365]
[null,{"$f":"IF(I19>365,\"Annual days of operation must be between 1 and 365.\",\"\")","v":""}]
[null,"For projects with dual-flush toilets"]
[null,"Enter the resulting flush rate into the design case flush rate section below."]
[null,{"$f":"CONCATENATE(\"Low flush \",IF(Instructions!$T$57=1,\"(gpf)\",\"(lpf)\"))","v":"Low flush (gpf)"}]
[null,{"$f":"CONCATENATE(\"Full flush \",IF(Instructions!$T$57=1,\"(gpf)\",\"(lpf)\"))","v":"Full flush (gpf)"}]
[null,{"$f":"CONCATENATE(\"LEED weighted average flush rate \",IF(Instructions!$T$57=1,\"(gpf)\",\"(lpf)\"))","v":"LEED weighted average flush rate (gpf)"},null,null,{"$f":"IFERROR(((K12*E23* (2-(I16*2)) )+(K13*2*E23)+(K12*E24)+(K13*E24))/((K12*(1+ (2-(I16*2)) )+(K13*(1+2)))),0)","v":0}]
[]
[null,"Table: Flush Fixtures"]
[null,"1. Indicate the Fixture ID that matches the information provided in the plumbing schedule.\n2. Select the Fixture Family and Fixture Type installed on the project.\n3. Enter the Design Flush Rate identified by the manufacturer - for dual flush toilets, use the dual flush calculator to determine average flush rate.\n4. Enter Percent of Occupants with access to the fixture. If the fixture is installed in all restrooms, use 100%. \n5. If necessary, modify the Total Uses per Day column for non-default uses."]
[null,"Fixture Information",null,null,null,null,"Flush Rate",null,"Percent of Occupants\n(%)",null,"Uses per Day",null,null,null,null,null,null,"Total Daily Uses",null,null,"Total Daily Water Use"]
[null,"Fixture \nID","Fixture Family","Fixture Type",null,null,{"$f":"CONCATENATE(\"Baseline \nFlush Rate\",IF(Instructions!T57=1,\"\n(gpf)\",\"\n(lpf)\"))","v":"Baseline \nFlush Rate\n(gpf)"},{"$f":"CONCATENATE(\"Design \nFlush Rate\",IF(Instructions!T57=1,\"\n(gpf)\",\"\n(lpf)\"))","v":"Design \nFlush Rate\n(gpf)"},null,null,"Employees\n(FTE)","Visitors","Retail Customers","Students\n(K-12)","Residential",{"$f":"IF($I$10=\"Other (specify)\",\"Other\",$I$10)","v":"Other"},null,"Default","Non-default\n(Optional)",null,{"$f":"CONCATENATE(\"Baseline\n\",IF(Instructions!$T$57=1,\"(gallons)\",\"(liters)\"))","v":"Baseline\n(gallons)"},{"$f":"CONCATENATE(\"Design \n\",IF(Instructions!$T$57=1,\"(gallons)\",\"(liters)\"))","v":"Design \n(gallons)"},null,"Helper column"]
[{"$f":"IF(B31>0,0,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(IF(Instructions!$T$57=1,VLOOKUP(C31,Instructions!$C$45:$J$47,5,TRUE),VLOOKUP(C31,Instructions!$C$45:$J$47,7,TRUE)),\"\")","v":""},null,null,null,{"$f":"IF($D$11>0,IF($C31=\"Toilet (male)\",1+(2*(1-$I$16)),IF($C31=\"Toilet (female)\",Instructions!$M$46,IF($C31=\"Urinal\",2*$I$16,0))),0)","v":0},{"$f":"IF($E$11>0,IF($C31=\"Toilet (male)\",0.1+(0.4*(1-$I$16)),IF($C31=\"Toilet (female)\",Instructions!$N$46,IF($C31=\"Urinal\",0.4*$I$16,0))),0)","v":0},{"$f":"IF($F$11>0,IF($C31=\"Toilet (male)\",0.1+(0.1*(1-$I$16)),IF($C31=\"Toilet (female)\",Instructions!$O$46,IF($C31=\"Urinal\",0.1*$I$16,0))),0)","v":0},{"$f":"IF($G$11>0,IF($C31=\"Toilet (male)\",1+(2*(1-$I$16)),IF($C31=\"Toilet (female)\",Instructions!$P$46,IF($C31=\"Urinal\",2*$I$16,0))),0)","v":0},{"$f":"IF($H$11>0,IF($C31=\"Toilet (male)\",Instructions!$Q$45,IF($C31=\"Toilet (female)\",Instructions!$Q$46,IF($C31=\"Urinal\",Instructions!$Q$47,0))),0)","v":0},null,null,{"$f":"IFERROR(IF(C31=\"Toilet (female)\",(($D$13*K31)+($E$13*L31)+($F$13*M31)+($G$13*N31)+($H$13*O31)+($I$13*P31)),(($D$12*K31)+($E$12*L31)+($F$12*M31)+($G$12*N31)+($H$12*O31)+($I$12*P31))),0)","v":0},null,null,{"$f":"IFERROR(IF($S31>0,G31*(S31*(I31/100)),G31*(R31*(I31/100))),0)","v":0},{"$f":"IFERROR(IF($S31>0,H31*(S31*(I31/100)),H31*(R31*(I31/100))),0)","v":0},null,{"$f":"IF(OR(C31=\"Toilet (male)\",C31=\"Toilet (female)\"),\"Toilet\",IF(C31=\"Urinal\",\"Urinal\",\"\"))","v":""}]
[{"$f":"IF(B32>0,0,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(IF(Instructions!$T$57=1,VLOOKUP(C32,Instructions!$C$45:$J$47,5,TRUE),VLOOKUP(C32,Instructions!$C$45:$J$47,7,TRUE)),\"\")","v":""},null,null,null,{"$f":"IF($D$11>0,IF($C32=\"Toilet (male)\",1+(2*(1-$I$16)),IF($C32=\"Toilet (female)\",Instructions!$M$46,IF($C32=\"Urinal\",2*$I$16,0))),0)","v":0},{"$f":"IF($E$11>0,IF($C32=\"Toilet (male)\",0.1+(0.4*(1-$I$16)),IF($C32=\"Toilet (female)\",Instructions!$N$46,IF($C32=\"Urinal\",0.4*$I$16,0))),0)","v":0},{"$f":"IF($F$11>0,IF($C32=\"Toilet (male)\",0.1+(0.1*(1-$I$16)),IF($C32=\"Toilet (female)\",Instructions!$O$46,IF($C32=\"Urinal\",0.1*$I$16,0))),0)","v":0},{"$f":"IF($G$11>0,IF($C32=\"Toilet (male)\",1+(2*(1-$I$16)),IF($C32=\"Toilet (female)\",Instructions!$P$46,IF($C32=\"Urinal\",2*$I$16,0))),0)","v":0},{"$f":"IF($H$11>0,IF($C32=\"Toilet (male)\",Instructions!$Q$45,IF($C32=\"Toilet (female)\",Instructions!$Q$46,IF($C32=\"Urinal\",Instructions!$Q$47,0))),0)","v":0},null,null,{"$f":"IFERROR(IF(C32=\"Toilet (female)\",(($D$13*K32)+($E$13*L32)+($F$13*M32)+($G$13*N32)+($H$13*O32)+($I$13*P32)),(($D$12*K32)+($E$12*L32)+($F$12*M32)+($G$12*N32)+($H$12*O32)+($I$12*P32))),0)","v":0},null,null,{"$f":"IFERROR(IF($S32>0,G32*(S32*(I32/100)),G32*(R32*(I32/100))),0)","v":0},{"$f":"IFERROR(IF($S32>0,H32*(S32*(I32/100)),H32*(R32*(I32/100))),0)","v":0},null,{"$f":"IF(OR(C32=\"Toilet (male)\",C32=\"Toilet (female)\"),\"Toilet\",IF(C32=\"Urinal\",\"Urinal\",\"\"))","v":""}]
[{"$f":"IF(B33>0,0,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(IF(Instructions!$T$57=1,VLOOKUP(C33,Instructions!$C$45:$J$47,5,TRUE),VLOOKUP(C33,Instructions!$C$45:$J$47,7,TRUE)),\"\")","v":""},null,null,null,{"$f":"IF($D$11>0,IF($C33=\"Toilet (male)\",1+(2*(1-$I$16)),IF($C33=\"Toilet (female)\",Instructions!$M$46,IF($C33=\"Urinal\",2*$I$16,0))),0)","v":0},{"$f":"IF($E$11>0,IF($C33=\"Toilet (male)\",0.1+(0.4*(1-$I$16)),IF($C33=\"Toilet (female)\",Instructions!$N$46,IF($C33=\"Urinal\",0.4*$I$16,0))),0)","v":0},{"$f":"IF($F$11>0,IF($C33=\"Toilet (male)\",0.1+(0.1*(1-$I$16)),IF($C33=\"Toilet (female)\",Instructions!$O$46,IF($C33=\"Urinal\",0.1*$I$16,0))),0)","v":0},{"$f":"IF($G$11>0,IF($C33=\"Toilet (male)\",1+(2*(1-$I$16)),IF($C33=\"Toilet (female)\",Instructions!$P$46,IF($C33=\"Urinal\",2*$I$16,0))),0)","v":0},{"$f":"IF($H$11>0,IF($C33=\"Toilet (male)\",Instructions!$Q$45,IF($C33=\"Toilet (female)\",Instructions!$Q$46,IF($C33=\"Urinal\",Instructions!$Q$47,0))),0)","v":0},null,null,{"$f":"IFERROR(IF(C33=\"Toilet (female)\",(($D$13*K33)+($E$13*L33)+($F$13*M33)+($G$13*N33)+($H$13*O33)+($I$13*P33)),(($D$12*K33)+($E$12*L33)+($F$12*M33)+($G$12*N33)+($H$12*O33)+($I$12*P33))),0)","v":0},null,null,{"$f":"IFERROR(IF($S33>0,G33*(S33*(I33/100)),G33*(R33*(I33/100))),0)","v":0},{"$f":"IFERROR(IF($S33>0,H33*(S33*(I33/100)),H33*(R33*(I33/100))),0)","v":0},null,{"$f":"IF(OR(C33=\"Toilet (male)\",C33=\"Toilet (female)\"),\"Toilet\",IF(C33=\"Urinal\",\"Urinal\",\"\"))","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(IF(Instructions!$T$57=1,VLOOKUP(C34,Instructions!$C$45:$J$47,5,TRUE),VLOOKUP(C34,Instructions!$C$45:$J$47,7,TRUE)),\"\")","v":""},null,null,null,{"$f":"IF($D$11>0,IF($C34=\"Toilet (male)\",1+(2*(1-$I$16)),IF($C34=\"Toilet (female)\",Instructions!$M$46,IF($C34=\"Urinal\",2*$I$16,0))),0)","v":0},{"$f":"IF($E$11>0,IF($C34=\"Toilet (male)\",0.1+(0.4*(1-$I$16)),IF($C34=\"Toilet (female)\",Instructions!$N$46,IF($C34=\"Urinal\",0.4*$I$16,0))),0)","v":0},{"$f":"IF($F$11>0,IF($C34=\"Toilet (male)\",0.1+(0.1*(1-$I$16)),IF($C34=\"Toilet (female)\",Instructions!$O$46,IF($C34=\"Urinal\",0.1*$I$16,0))),0)","v":0},{"$f":"IF($G$11>0,IF($C34=\"Toilet (male)\",1+(2*(1-$I$16)),IF($C34=\"Toilet (female)\",Instructions!$P$46,IF($C34=\"Urinal\",2*$I$16,0))),0)","v":0},{"$f":"IF($H$11>0,IF($C34=\"Toilet (male)\",Instructions!$Q$45,IF($C34=\"Toilet (female)\",Instructions!$Q$46,IF($C34=\"Urinal\",Instructions!$Q$47,0))),0)","v":0},null,null,{"$f":"IFERROR(IF(C34=\"Toilet (female)\",(($D$13*K34)+($E$13*L34)+($F$13*M34)+($G$13*N34)+($H$13*O34)+($I$13*P34)),(($D$12*K34)+($E$12*L34)+($F$12*M34)+($G$12*N34)+($H$12*O34)+($I$12*P34))),0)","v":0},null,null,{"$f":"IFERROR(IF($S34>0,G34*(S34*(I34/100)),G34*(R34*(I34/100))),0)","v":0},{"$f":"IFERROR(IF($S34>0,H34*(S34*(I34/100)),H34*(R34*(I34/100))),0)","v":0},null,{"$f":"IF(OR(C34=\"Toilet (male)\",C34=\"Toilet (female)\"),\"Toilet\",IF(C34=\"Urinal\",\"Urinal\",\"\"))","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(IF(Instructions!$T$57=1,VLOOKUP(C35,Instructions!$C$45:$J$47,5,TRUE),VLOOKUP(C35,Instructions!$C$45:$J$47,7,TRUE)),\"\")","v":""},null,null,null,{"$f":"IF($D$11>0,IF($C35=\"Toilet (male)\",1+(2*(1-$I$16)),IF($C35=\"Toilet (female)\",Instructions!$M$46,IF($C35=\"Urinal\",2*$I$16,0))),0)","v":0},{"$f":"IF($E$11>0,IF($C35=\"Toilet (male)\",0.1+(0.4*(1-$I$16)),IF($C35=\"Toilet (female)\",Instructions!$N$46,IF($C35=\"Urinal\",0.4*$I$16,0))),0)","v":0},{"$f":"IF($F$11>0,IF($C35=\"Toilet (male)\",0.1+(0.1*(1-$I$16)),IF($C35=\"Toilet (female)\",Instructions!$O$46,IF($C35=\"Urinal\",0.1*$I$16,0))),0)","v":0},{"$f":"IF($G$11>0,IF($C35=\"Toilet (male)\",1+(2*(1-$I$16)),IF($C35=\"Toilet (female)\",Instructions!$P$46,IF($C35=\"Urinal\",2*$I$16,0))),0)","v":0},{"$f":"IF($H$11>0,IF($C35=\"Toilet (male)\",Instructions!$Q$45,IF($C35=\"Toilet (female)\",Instructions!$Q$46,IF($C35=\"Urinal\",Instructions!$Q$47,0))),0)","v":0},null,null,{"$f":"IFERROR(IF(C35=\"Toilet (female)\",(($D$13*K35)+($E$13*L35)+($F$13*M35)+($G$13*N35)+($H$13*O35)+($I$13*P35)),(($D$12*K35)+($E$12*L35)+($F$12*M35)+($G$12*N35)+($H$12*O35)+($I$12*P35))),0)","v":0},null,null,{"$f":"IFERROR(IF($S35>0,G35*(S35*(I35/100)),G35*(R35*(I35/100))),0)","v":0},{"$f":"IFERROR(IF($S35>0,H35*(S35*(I35/100)),H35*(R35*(I35/100))),0)","v":0},null,{"$f":"IF(OR(C35=\"Toilet (male)\",C35=\"Toilet (female)\"),\"Toilet\",IF(C35=\"Urinal\",\"Urinal\",\"\"))","v":""}]
["A",{"$f":"CONCATENATE(\"Baseline case annual flush volume \",IF(Instructions!$T$57=1,\"(gallons/year)\",\"(liters/year)\"))","v":"Baseline case annual flush volume (gallons/year)"},null,null,null,null,null,null,{"$f":"(SUM(U31:U35)*$I$19)","v":0}]
[null,{"$f":"CONCATENATE(\"Design case annual flush volume \",IF(Instructions!$T$57=1,\"(gallons/year)\",\"(liters/year)\"))","v":"Design case annual flush volume (gallons/year)"},null,null,null,null,null,null,{"$f":"(SUM(V31:V35)*$I$19)","v":0}]
[]
[]
[null,"Table: Flow Fixtures"]
[null,"1. Indicate the Fixture ID that matches the information provided in the plumbing schedule.\n2. Select the Fixture Type installed on the project.\n3. If necessary, modify the Duration column for non-default values.\n4. Enter the Design Flow Rate identified by the manufacturer.\n5. Enter Percent of Occupants with access to the fixture. If the fixture is installed in all restrooms, use 100%.\n6. If necessary, modify the Total Uses per Day column for non-default uses."]
[null,"Fixture Information",null,null,"Duration",null,"Flow Rate",null,"Percent of Occupants\n(%)",null,"Uses per Day",null,null,null,null,null,null,"Total Daily Uses",null,null,"Total Daily Water Use"]
[null,"Fixture \nID","Fixture Type",null,"Default\n(sec)","Non-default\n(sec)\n(Optional)",{"$f":"CONCATENATE(\"Baseline \nFlow Rate\",IF(Instructions!$T$57=1,\"\n(gpm)\",\"\n(lpm)\"))","v":"Baseline \nFlow Rate\n(gpm)"},{"$f":"CONCATENATE(\"Design \nFlow Rate\",IF(Instructions!$T$57=1,\"\n(gpm)\",\"\n(lpm)\"))","v":"Design \nFlow Rate\n(gpm)"},null,null,"Employees\n(FTE)","Visitors","Retail Customers","Students\n(K-12)","Residential",{"$f":"IF($I$10=\"Other (specify)\",\"Other\",$I$10)","v":"Other"},null,"Default","Non-default\n(Optional)",null,{"$f":"CONCATENATE(\"Baseline\n\",IF(Instructions!$T$57=1,\"(gallons)\",\"(liters)\"))","v":"Baseline\n(gallons)"},{"$f":"CONCATENATE(\"Design \n\",IF(Instructions!$T$57=1,\"(gallons)\",\"(liters)\"))","v":"Design \n(gallons)"}]
[{"$f":"IF(B44>0,1,1)","v":1},null,null,null,{"$f":"IFERROR(VLOOKUP(C44,Instructions!$C$45:$K$53,9,FALSE),\"\")","v":""},null,{"$f":"IFERROR(IF(Instructions!$T$57=1,VLOOKUP(C44,Instructions!$C$45:$K$53,5,FALSE),VLOOKUP(C44,Instructions!$C$45:$K$53,7,FALSE)),\"\")","v":""},null,null,null,{"$f":"IF($D$11>0,IFERROR(VLOOKUP($C44,Instructions!$C$45:$Q$53,11,FALSE),0),0)","v":0},{"$f":"IF($E$11>0,IFERROR(VLOOKUP($C44,Instructions!$C$45:$Q$53,12,FALSE),0),0)","v":0},{"$f":"IF($F$11>0,IFERROR(VLOOKUP($C44,Instructions!$C$45:$Q$53,13,FALSE),0),0)","v":0},{"$f":"IF($G$11>0,IFERROR(VLOOKUP($C44,Instructions!$C$45:$Q$53,14,FALSE),0),0)","v":0},{"$f":"IF($H$11>0,IFERROR(VLOOKUP($C44,Instructions!$C$45:$Q$53,15,FALSE),0),0)","v":0},null,null,{"$f":"IFERROR(($D$11*K44)+($E$11*L44)+($F$11*M44)+($G$11*N44)+($H$11*O44)+($I$11*P44),0)","v":0},null,null,{"$f":"IFERROR(IF(S44>0,\n   IF(E44=\"n/a\",G44*(S44*(I44/100))*(60/60),\n       IF(F44>0,G44*(S44*(I44/100))*(F44/60), G44*(S44*(I44/100))*(E44/60))),\n   IF(E44=\"n/a\",G44*(R44*(I44/100))*(60/60),\n       IF(F44<0,G44*(R44*(I44/100))*(F44/60), G44*(R44*(I44/100))*(E44/60)))\n),0)","v":0},{"$f":"IFERROR(IF(S44>0,\n   IF(E44=\"n/a\",H44*(S44*(I44/100))*(60/60),\n       IF(F44>0,H44*(S44*(I44/100))*(F44/60), H44*(S44*(I44/100))*(E44/60))),\n   IF(E44=\"n/a\",H44*(R44*(I44/100))*(60/60),\n       IF(F44>0,H44*(R44*(I44/100))*(F44/60), H44*(R44*(I44/100))*(E44/60)))\n),0)","v":0}]
[{"$f":"IF(B45>0,1,1)","v":1},null,null,null,{"$f":"IFERROR(VLOOKUP(C45,Instructions!$C$45:$K$53,9,FALSE),\"\")","v":""},null,{"$f":"IFERROR(IF(Instructions!$T$57=1,VLOOKUP(C45,Instructions!$C$45:$K$53,5,FALSE),VLOOKUP(C45,Instructions!$C$45:$K$53,7,FALSE)),\"\")","v":""},null,null,null,{"$f":"IF($D$11>0,IFERROR(VLOOKUP($C45,Instructions!$C$45:$Q$53,11,FALSE),0),0)","v":0},{"$f":"IF($E$11>0,IFERROR(VLOOKUP($C45,Instructions!$C$45:$Q$53,12,FALSE),0),0)","v":0},{"$f":"IF($F$11>0,IFERROR(VLOOKUP($C45,Instructions!$C$45:$Q$53,13,FALSE),0),0)","v":0},{"$f":"IF($G$11>0,IFERROR(VLOOKUP($C45,Instructions!$C$45:$Q$53,14,FALSE),0),0)","v":0},{"$f":"IF($H$11>0,IFERROR(VLOOKUP($C45,Instructions!$C$45:$Q$53,15,FALSE),0),0)","v":0},null,null,{"$f":"IFERROR(($D$11*K45)+($E$11*L45)+($F$11*M45)+($G$11*N45)+($H$11*O45)+($I$11*P45),0)","v":0},null,null,{"$f":"IFERROR(IF(S45>0,\n   IF(E45=\"n/a\",G45*(S45*(I45/100))*(60/60),\n       IF(F45>0,G45*(S45*(I45/100))*(F45/60), G45*(S45*(I45/100))*(E45/60))),\n   IF(E45=\"n/a\",G45*(R45*(I45/100))*(60/60),\n       IF(F45<0,G45*(R45*(I45/100))*(F45/60), G45*(R45*(I45/100))*(E45/60)))\n),0)","v":0},{"$f":"IFERROR(IF(S45>0,\n   IF(E45=\"n/a\",H45*(S45*(I45/100))*(60/60),\n       IF(F45>0,H45*(S45*(I45/100))*(F45/60), H45*(S45*(I45/100))*(E45/60))),\n   IF(E45=\"n/a\",H45*(R45*(I45/100))*(60/60),\n       IF(F45>0,H45*(R45*(I45/100))*(F45/60), H45*(R45*(I45/100))*(E45/60)))\n),0)","v":0}]
[{"$f":"IF(B46>0,1,1)","v":1},null,null,null,{"$f":"IFERROR(VLOOKUP(C46,Instructions!$C$45:$K$53,9,FALSE),\"\")","v":""},null,{"$f":"IFERROR(IF(Instructions!$T$57=1,VLOOKUP(C46,Instructions!$C$45:$K$53,5,FALSE),VLOOKUP(C46,Instructions!$C$45:$K$53,7,FALSE)),\"\")","v":""},null,null,null,{"$f":"IF($D$11>0,IFERROR(VLOOKUP($C46,Instructions!$C$45:$Q$53,11,FALSE),0),0)","v":0},{"$f":"IF($E$11>0,IFERROR(VLOOKUP($C46,Instructions!$C$45:$Q$53,12,FALSE),0),0)","v":0},{"$f":"IF($F$11>0,IFERROR(VLOOKUP($C46,Instructions!$C$45:$Q$53,13,FALSE),0),0)","v":0},{"$f":"IF($G$11>0,IFERROR(VLOOKUP($C46,Instructions!$C$45:$Q$53,14,FALSE),0),0)","v":0},{"$f":"IF($H$11>0,IFERROR(VLOOKUP($C46,Instructions!$C$45:$Q$53,15,FALSE),0),0)","v":0},null,null,{"$f":"IFERROR(($D$11*K46)+($E$11*L46)+($F$11*M46)+($G$11*N46)+($H$11*O46)+($I$11*P46),0)","v":0},null,null,{"$f":"IFERROR(IF(S46>0,\n   IF(E46=\"n/a\",G46*(S46*(I46/100))*(60/60),\n       IF(F46>0,G46*(S46*(I46/100))*(F46/60), G46*(S46*(I46/100))*(E46/60))),\n   IF(E46=\"n/a\",G46*(R46*(I46/100))*(60/60),\n       IF(F46<0,G46*(R46*(I46/100))*(F46/60), G46*(R46*(I46/100))*(E46/60)))\n),0)","v":0},{"$f":"IFERROR(IF(S46>0,\n   IF(E46=\"n/a\",H46*(S46*(I46/100))*(60/60),\n       IF(F46>0,H46*(S46*(I46/100))*(F46/60), H46*(S46*(I46/100))*(E46/60))),\n   IF(E46=\"n/a\",H46*(R46*(I46/100))*(60/60),\n       IF(F46>0,H46*(R46*(I46/100))*(F46/60), H46*(R46*(I46/100))*(E46/60)))\n),0)","v":0}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(C47,Instructions!$C$45:$K$53,9,FALSE),\"\")","v":""},null,{"$f":"IFERROR(IF(Instructions!$T$57=1,VLOOKUP(C47,Instructions!$C$45:$K$53,5,FALSE),VLOOKUP(C47,Instructions!$C$45:$K$53,7,FALSE)),\"\")","v":""},null,null,null,{"$f":"IF($D$11>0,IFERROR(VLOOKUP($C47,Instructions!$C$45:$Q$53,11,FALSE),0),0)","v":0},{"$f":"IF($E$11>0,IFERROR(VLOOKUP($C47,Instructions!$C$45:$Q$53,12,FALSE),0),0)","v":0},{"$f":"IF($F$11>0,IFERROR(VLOOKUP($C47,Instructions!$C$45:$Q$53,13,FALSE),0),0)","v":0},{"$f":"IF($G$11>0,IFERROR(VLOOKUP($C47,Instructions!$C$45:$Q$53,14,FALSE),0),0)","v":0},{"$f":"IF($H$11>0,IFERROR(VLOOKUP($C47,Instructions!$C$45:$Q$53,15,FALSE),0),0)","v":0},null,null,{"$f":"IFERROR(($D$11*K47)+($E$11*L47)+($F$11*M47)+($G$11*N47)+($H$11*O47)+($I$11*P47),0)","v":0},null,null,{"$f":"IFERROR(IF(S47>0,\n   IF(E47=\"n/a\",G47*(S47*(I47/100))*(60/60),\n       IF(F47>0,G47*(S47*(I47/100))*(F47/60), G47*(S47*(I47/100))*(E47/60))),\n   IF(E47=\"n/a\",G47*(R47*(I47/100))*(60/60),\n       IF(F47<0,G47*(R47*(I47/100))*(F47/60), G47*(R47*(I47/100))*(E47/60)))\n),0)","v":0},{"$f":"IFERROR(IF(S47>0,\n   IF(E47=\"n/a\",H47*(S47*(I47/100))*(60/60),\n       IF(F47>0,H47*(S47*(I47/100))*(F47/60), H47*(S47*(I47/100))*(E47/60))),\n   IF(E47=\"n/a\",H47*(R47*(I47/100))*(60/60),\n       IF(F47>0,H47*(R47*(I47/100))*(F47/60), H47*(R47*(I47/100))*(E47/60)))\n),0)","v":0}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(C48,Instructions!$C$45:$K$53,9,FALSE),\"\")","v":""},null,{"$f":"IFERROR(IF(Instructions!$T$57=1,VLOOKUP(C48,Instructions!$C$45:$K$53,5,FALSE),VLOOKUP(C48,Instructions!$C$45:$K$53,7,FALSE)),\"\")","v":""},null,null,null,{"$f":"IF($D$11>0,IFERROR(VLOOKUP($C48,Instructions!$C$45:$Q$53,11,FALSE),0),0)","v":0},{"$f":"IF($E$11>0,IFERROR(VLOOKUP($C48,Instructions!$C$45:$Q$53,12,FALSE),0),0)","v":0},{"$f":"IF($F$11>0,IFERROR(VLOOKUP($C48,Instructions!$C$45:$Q$53,13,FALSE),0),0)","v":0},{"$f":"IF($G$11>0,IFERROR(VLOOKUP($C48,Instructions!$C$45:$Q$53,14,FALSE),0),0)","v":0},{"$f":"IF($H$11>0,IFERROR(VLOOKUP($C48,Instructions!$C$45:$Q$53,15,FALSE),0),0)","v":0},null,null,{"$f":"IFERROR(($D$11*K48)+($E$11*L48)+($F$11*M48)+($G$11*N48)+($H$11*O48)+($I$11*P48),0)","v":0},null,null,{"$f":"IFERROR(IF(S48>0,\n   IF(E48=\"n/a\",G48*(S48*(I48/100))*(60/60),\n       IF(F48>0,G48*(S48*(I48/100))*(F48/60), G48*(S48*(I48/100))*(E48/60))),\n   IF(E48=\"n/a\",G48*(R48*(I48/100))*(60/60),\n       IF(F48<0,G48*(R48*(I48/100))*(F48/60), G48*(R48*(I48/100))*(E48/60)))\n),0)","v":0},{"$f":"IFERROR(IF(S48>0,\n   IF(E48=\"n/a\",H48*(S48*(I48/100))*(60/60),\n       IF(F48>0,H48*(S48*(I48/100))*(F48/60), H48*(S48*(I48/100))*(E48/60))),\n   IF(E48=\"n/a\",H48*(R48*(I48/100))*(60/60),\n       IF(F48>0,H48*(R48*(I48/100))*(F48/60), H48*(R48*(I48/100))*(E48/60)))\n),0)","v":0}]
["B",{"$f":"CONCATENATE(\"Baseline case annual flow volume \",IF(Instructions!$T$57=1,\"(gallons/year)\",\"(liters/year)\"))","v":"Baseline case annual flow volume (gallons/year)"},null,null,null,null,null,null,{"$f":"SUM(U44:U48)*$I$19","v":0}]
[null,{"$f":"CONCATENATE(\"Design case annual flow volume \",IF(Instructions!$T$57=1,\"(gallons/year)\",\"(liters/year)\"))","v":"Design case annual flow volume (gallons/year)"},null,null,null,null,null,null,{"$f":"SUM(V44:V48)*$I$19","v":0}]

{"sheet":"Lowrise Indoor Water Use","index":3,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":true,"merged":[[6,13,7,13],[13,1,13,12],[14,1,14,12],[15,1,15,12],[6,1,7,1],[6,2,6,4],[6,5,6,7],[6,8,6,10],[6,11,6,12]]}
[]
[null,{"$f":"REPLACE(CELL(\"filename\",A1),1,FIND(\"]\",CELL(\"filename\",A1)),\"\")","v":"Lowrise Indoor Water Use"}]
[null,"For ND projects with new single-family residential and multiunit residential buildings three stories or fewer"]
[]
[]
[null,"Complete the table for all new single-family residential and new multiunit residential buildings three stories or fewer."]
[null,"Building ID","Lavatory Faucet",null,null,"Showerheads",null,null,"Toilets",null,null,"Clothes Washers",null,"Total \nWE Credit Indoor Water Use\nPoints"]
[null,null,"WaterSense \nor equivalent\nlabeled",{"$f":"CONCATENATE(\"Average rated flow volume\n\",IF(UOM=1,\" (gpm)\",\" (lpm)\"))","v":"Average rated flow volume\n (gpm)"},"Points","WaterSense \nor equivalent\nlabeled",{"$f":"CONCATENATE(\"Average rated flow volume\n\",IF(UOM=1,\" (gpm)\",\" (lpm)\"))","v":"Average rated flow volume\n (gpm)"},"Points","WaterSense \nor equivalent\nlabeled",{"$f":"CONCATENATE(\"Average rated flush volume\n\",IF(UOM=1,\" (gpf)\",\" (lpf)\"))","v":"Average rated flush volume\n (gpf)"},"Points","ENERGY \nSTAR qualified or equivalent","Points"]
[{"$f":"IF(B9>0,0,0)","v":0},null,null,null,{"$f":"IF(C9=\"Yes\",IF(UOM=2,IF(AND(D9>0,D9<=3.7),2,IF(AND(D9>0,D9<=5.6),1,0)),IF(AND(D9>0,D9<=1),2,IF(AND(D9>0,D9<=1.5),1,0))),0)","v":0},null,null,{"$f":"IF(F9=\"Yes\",IF(UOM=2,IF(AND(G9>0,G9<=5.6),2,IF(AND(G9>0,G9<=6.6),1,0)),IF(AND(G9>0,G9<=1.5),2,IF(AND(G9>0,G9<=1.75),1,0))),0)","v":0},null,null,{"$f":"IF(I9=\"Yes\",IF(UOM=2,IF(AND(J9>0,J9<=4.1),1,0),IF(AND(J9>0,J9<=1.1),1,0)),0)","v":0},null,{"$f":"IF(L9=\"Yes\",1,0)","v":0},{"$f":"SUM(E9,H9,K9,M9)","v":0}]
[{"$f":"IF(B10>0,0,0)","v":0},null,null,null,0,null,null,0,null,null,0,null,{"$f":"IF(L10=\"Yes\",1,0)","v":0},{"$f":"SUM(E10,H10,K10,M10)","v":0}]
[0,null,null,null,0,null,null,0,null,null,0,null,0,0]
[null,null,null,null,0,null,null,0,null,null,0,null,0,0]
[null,null,null,null,0,null,null,0,null,null,0,null,0,0]
["A","Total number of new single-family residential buildings and new multiunit residential buildings three stories or fewer",null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(B9:B13)","v":0}]
[null,"Total number of residential buildings that would earn at least 2 points under LEED v4 for Homes WE Credit Indoor Water Use",null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N9:N13,\">=2\")","v":0}]
[null,"For project pursuing GIB Credit Indoor Water Use: Total number of residential buildings that would earn at least 4 points under LEED v4 for Homes WE Credit Indoor Water Use",null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N9:N13,\">=4\")","v":0}]

{"sheet":"Lowrise Wastewater Use","index":4,"n_rows":138,"n_cols":23,"rows_kept":138,"cut":false,"hidden":true,"merged":[[20,1,20,3],[22,1,22,2],[29,1,29,4],[30,1,30,4],[30,15,30,17],[30,18,30,19],[5,1,5,8],[8,1,8,3],[31,17,32,17],[31,18,32,18],[31,19,32,19],[31,21,32,21],[48,1,48,4],[48,5,48,14],[48,15,48,17],[48,18,48,19],[31,9,31,10],[31,11,31,12],[31,13,32,13],[31,14,32,14],[31,15,32,15],[31,16,32,16],[31,1,32,1],[31,2,32,2],[31,3,32,3],[31,4,32,4],[31,5,31,6],[31,7,31,8],[49,17,50,17],[49,18,50,18],[49,19,50,19],[49,21,50,21],[61,1,61,4],[72,1,72,4],[72,15,72,17],[72,18,72,19],[49,9,49,10],[49,11,49,12],[49,13,50,13],[49,14,50,14],[49,15,50,15],[49,16,50,16],[49,1,50,1],[49,2,50,2],[49,3,50,3],[49,4,50,4],[49,5,49,6],[49,7,49,8],[73,17,74,17],[73,18,74,18],[73,19,74,19],[73,21,74,21],[84,1,84,2],[91,1,91,4],[91,15,91,17],[91,18,91,19],[73,9,73,10],[73,11,73,12],[73,13,74,13],[73,14,74,14],[73,15,74,15],[73,16,74,16],[73,1,74,1],[73,2,74,2],[73,3,74,3],[73,4,74,4],[73,5,73,6],[73,7,73,8],[92,17,93,17],[92,18,93,18],[92,19,93,19],[92,21,93,21],[103,1,103,2],[110,1,110,4],[110,15,110,17],[110,18,110,19],[92,9,92,10],[92,11,92,12],[92,13,93,13],[92,14,93,14],[92,15,93,15],[92,16,93,16],[92,1,93,1],[92,2,93,2],[92,3,93,3],[92,4,93,4],[92,5,92,6],[92,7,92,8],[111,17,112,17],[111,18,112,18],[111,19,112,19],[111,21,112,21],[122,1,122,5],[123,1,123,5],[111,9,111,10],[111,11,111,12],[111,13,112,13],[111,14,112,14],[111,15,112,15],[111,16,112,16],[111,1,112,1],[111,2,112,2],[111,3,112,3],[111,4,112,4],[111,5,111,6],[111,7,111,8],[131,9,131,10],[132,5,132,6],[132,7,132,8],[131,1,132,1],[131,2,132,4],[131,5,131,8],[124,1,124,5],[125,1,125,5],[126,1,126,5],[127,1,127,5]]}
[]
[null,"Lowrise Wastewater Use"]
[null,"For ND projects with new single-family residential and multiunit residential buildings three stories or fewer and pursuing GIB Credit Wastewater Management"]
[]
[]
[null,"Complete the tables below for all single-family residential and multiunit residential buildings three stories or more."]
[]
[null,"Unit Information"]
[null,"List the number of each type of unit for the building. This information is used to double check your entries for each fixture type.  For new single family homes, put  '1' by the number of bedrooms."]
[null,"Unit Type","Number of \nUnits","Occupants",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of Bedrooms","All units"]
[{"$f":"IF(B11>0,0,0)","v":0},"Efficiency",null,{"$f":"(1+1)*C11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Efficiency"]
[{"$f":"IF(B12>0,0,0)","v":0},"1 Bedroom",null,{"$f":"(1+1)*C12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"1 Bedroom"]
[{"$f":"IF(B13>0,0,0)","v":0},"2 Bedrooms",null,{"$f":"(2+1)*C13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"2 Bedrooms"]
[{"$f":"IF(B14>0,0,0)","v":0},"3 Bedrooms",null,{"$f":"(3+1)*C14","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"3 Bedrooms"]
[0,"4 Bedrooms",null,{"$f":"(4+1)*C15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"4 Bedrooms"]
[null,"5 Bedrooms",null,{"$f":"(5+1)*C16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"5 Bedrooms"]
[null,"6 Bedrooms",null,{"$f":"(6+1)*C17","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"6 Bedrooms"]
[null,"Totals",{"$f":"SUM(C11:C17)","v":0},{"$f":"SUM(D11:D17)","v":0}]
["A"]
[null,"Indoor Water Use"]
[null,"This section determines the average flow rate of each fixture, for each unique unit type which is used to calculate the average indoor water use for each unit's occupants."]
[null,"Fixture Use for Showers"]
[null,"Enter the flow rate and a brief description for each type of fixture."]
[null,"Fixture ID",{"$f":"CONCATENATE(\"Flow Rate\n\",IF(UOM=1,\"(gpm)\",\"(lpm)\"))","v":"Flow Rate\n(gpm)"}]
[{"$f":"IF(B25>0,0,0)","v":0}]
[{"$f":"IF(B26>0,0,0)","v":0}]
[{"$f":"IF(B27>0,0,0)","v":0}]
[]
[]
[null,"Complete one row for each unique set of units and enter each fixture's information. This will calculate the average water use of the occupant of each unit type. If the fixture is the same throughout the building, select 'All units' under 'Unit Type' and select the appropriate fixture in Fixture 1."]
[null,"Unit Information",null,null,null,"Design",null,null,null,null,null,null,null,null,null,"Baseline",null,null,"Totals"]
[null,"Unit Type","Unit \nDescription","Number of \nUnits","Occupants","Fixture 1",null,"Fixture 2",null,"Fixture 3",null,"Fixture 4",null,{"$f":"CONCATENATE(\"Average \nFlow Rate\n\",IF(UOM=1,\"(gpm)\",\"(lpm)\"))","v":"Average \nFlow Rate\n(gpm)"},{"$f":"CONCATENATE(\"Calculated\nWater Usage\n\",IF(UOM=1,\" (gallons)\",\" (liters)\"))","v":"Calculated\nWater Usage\n (gallons)"},"Estimated Fixture Usage\n(minutes)",{"$f":"CONCATENATE(\"Flow Rate\n\",IF(UOM=1,\"(gpm)\",\"(lpm)\"))","v":"Flow Rate\n(gpm)"},{"$f":"CONCATENATE(\"Estimated\nWater Usage\n\",IF(UOM=1,\" (gallons)\",\" (liters)\"))","v":"Estimated\nWater Usage\n (gallons)"},{"$f":"CONCATENATE(\"Design \nMonthly \nWater Use\n\",IF(UOM=1,\" (gal/month)\",\" (l/month)\"))","v":"Design \nMonthly \nWater Use\n (gal/month)"},{"$f":"CONCATENATE(\"Baseline Monthly \nWater Use\n\",IF(UOM=1,\" (gal/month)\",\" (l/month)\"))","v":"Baseline Monthly \nWater Use\n (gal/month)"},null,"Number of Bedrooms"]
[null,null,null,null,null,"Fixture 1 \nID",{"$f":"CONCATENATE(\"Fixture 1 \nFlow Rate\n\",IF(UOM=1,\"(gpm)\",\"(lpm)\"))","v":"Fixture 1 \nFlow Rate\n(gpm)"},"Fixture 2\nID",{"$f":"CONCATENATE(\"Fixture 2 \nFlow Rate\n\",IF(UOM=1,\"(gpm)\",\"(lpm)\"))","v":"Fixture 2 \nFlow Rate\n(gpm)"},"Fixture 3\nID",{"$f":"CONCATENATE(\"Fixture 3 \nFlow Rate\n\",IF(UOM=1,\"(gpm)\",\"(lpm)\"))","v":"Fixture 3 \nFlow Rate\n(gpm)"},"Fixture 4\nID",{"$f":"CONCATENATE(\"Fixture 4 \nFlow Rate\n\",IF(UOM=1,\"(gpm)\",\"(lpm)\"))","v":"Fixture 4 \nFlow Rate\n(gpm)"}]
[{"$f":"IF(B34>0,0,0)","v":0},null,null,null,{"$f":"IFERROR(IF(B34=\"All units\",$D$18,(V34+1)*D34),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(F34,$B$25:$C$28,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H34,$B$25:$C$28,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(J34,$B$25:$C$28,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(L34,$B$25:$C$28,2,FALSE),\"\")","v":""},{"$f":"IFERROR(SUM(G34,I34,K34,M34)/COUNTA(F34,H34,J34,L34),\"\")","v":""},{"$f":"IFERROR(N34*$P34,\"\")","v":""},{"$f":"IF(B34<>\"\",$C$134,\"\")","v":""},{"$f":"IF(B34<>\"\",IF(UOM=1,$F$134,$H$134),\"\")","v":""},{"$f":"IF(B34<>\"\",IF(UOM=1,$J$134,$K$134),\"\")","v":""},{"$f":"IFERROR(O34*30*$E34,\"\")","v":""},{"$f":"IFERROR(R34*30*$E34,\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B34,$B$11:$V$17,21,FALSE),\"\")","v":""}]
[{"$f":"IF(B35>0,0,0)","v":0},null,null,null,{"$f":"IFERROR(IF(B35=\"All units\",$D$18,(V35+1)*D35),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(F35,$B$25:$C$28,2,FALSE),\"\")","v":""},null,"",null,{"$f":"IFERROR(VLOOKUP(J35,$B$25:$C$28,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(L35,$B$25:$C$28,2,FALSE),\"\")","v":""},{"$f":"IFERROR(SUM(G35,I35,K35,M35)/COUNTA(F35,H35,J35,L35),\"\")","v":""},{"$f":"IFERROR(N35*$P35,\"\")","v":""},{"$f":"IF(B35<>\"\",$C$134,\"\")","v":""},{"$f":"IF(B35<>\"\",IF(UOM=1,$F$134,$H$134),\"\")","v":""},{"$f":"IF(B35<>\"\",IF(UOM=1,$J$134,$K$134),\"\")","v":""},{"$f":"IFERROR(O35*30*$E35,\"\")","v":""},{"$f":"IFERROR(R35*30*$E35,\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B35,$B$11:$V$17,21,FALSE),\"\")","v":""}]
[{"$f":"IF(B36>0,0,0)","v":0},null,null,null,{"$f":"IFERROR(IF(B36=\"All units\",$D$18,(V36+1)*D36),0)","v":0},null,"",null,"",null,"",null,"","",{"$f":"IFERROR(N36*$P36,\"\")","v":""},{"$f":"IF(B36<>\"\",$C$134,\"\")","v":""},{"$f":"IF(B36<>\"\",IF(UOM=1,$F$134,$H$134),\"\")","v":""},{"$f":"IF(B36<>\"\",IF(UOM=1,$J$134,$K$134),\"\")","v":""},{"$f":"IFERROR(O36*30*$E36,\"\")","v":""},{"$f":"IFERROR(R36*30*$E36,\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B36,$B$11:$V$17,21,FALSE),\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(B37=\"All units\",$D$18,(V37+1)*D37),0)","v":0},null,"",null,"",null,"",null,"","",{"$f":"IFERROR(N37*$P37,\"\")","v":""},{"$f":"IF(B37<>\"\",$C$134,\"\")","v":""},{"$f":"IF(B37<>\"\",IF(UOM=1,$F$134,$H$134),\"\")","v":""},{"$f":"IF(B37<>\"\",IF(UOM=1,$J$134,$K$134),\"\")","v":""},{"$f":"IFERROR(O37*30*$E37,\"\")","v":""},{"$f":"IFERROR(R37*30*$E37,\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B37,$B$11:$V$17,21,FALSE),\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(B38=\"All units\",$D$18,(V38+1)*D38),0)","v":0},null,"",null,"",null,"",null,"","",{"$f":"IFERROR(N38*$P38,\"\")","v":""},{"$f":"IF(B38<>\"\",$C$134,\"\")","v":""},{"$f":"IF(B38<>\"\",IF(UOM=1,$F$134,$H$134),\"\")","v":""},{"$f":"IF(B38<>\"\",IF(UOM=1,$J$134,$K$134),\"\")","v":""},{"$f":"IFERROR(O38*30*$E38,\"\")","v":""},{"$f":"IFERROR(R38*30*$E38,\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B38,$B$11:$V$17,21,FALSE),\"\")","v":""}]
["B","Totals for showers",null,{"$f":"SUM(D34:D38)","v":0},{"$f":"SUM(E34:E38)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S34:S38)","v":0},{"$f":"SUM(T34:T38)","v":0}]
[]
[]
[null,"Fixture Use for Lavatories and Kitchen Faucets"]
[null,"Fixture ID",{"$f":"CONCATENATE(\"Flow Rate\n\",IF(UOM=1,\"(gpm)\",\"(lpm)\"))","v":"Flow Rate\n(gpm)"}]
[{"$f":"IF(B44>0,0,0)","v":0}]
[{"$f":"IF(B45>0,0,0)","v":0}]
[{"$f":"IF(B46>0,0,0)","v":0}]
[]
[]
[null,"Unit Information",null,null,null,"Design",null,null,null,null,null,null,null,null,null,"Baseline",null,null,"Totals"]
[null,"Unit Type","Unit \nDescription","Number of \nUnits","Occupants","Fixture 1",null,"Fixture 2",null,"Fixture 3",null,"Fixture 4",null,{"$f":"CONCATENATE(\"Average \nFlow Rate\n\",IF(UOM=1,\"(gpm)\",\"(lpm)\"))","v":"Average \nFlow Rate\n(gpm)"},{"$f":"CONCATENATE(\"Calculated\nWater Usage\n\",IF(UOM=1,\" (gallons)\",\" (liters)\"))","v":"Calculated\nWater Usage\n (gallons)"},"Estimated Fixture Usage\n(minutes)",{"$f":"CONCATENATE(\"Flow Rate\n\",IF(UOM=1,\"(gpm)\",\"(lpm)\"))","v":"Flow Rate\n(gpm)"},{"$f":"CONCATENATE(\"Estimated\nWater Usage\n\",IF(UOM=1,\" (gallons)\",\" (liters)\"))","v":"Estimated\nWater Usage\n (gallons)"},{"$f":"CONCATENATE(\"Design\nMonthly \nWater Use\n\",IF(UOM=1,\" (gal/month)\",\" (l/month)\"))","v":"Design\nMonthly \nWater Use\n (gal/month)"},{"$f":"CONCATENATE(\"Baseline Monthly \nWater Use\n\",IF(UOM=1,\" (gal/month)\",\" (l/month)\"))","v":"Baseline Monthly \nWater Use\n (gal/month)"},null,"Number of Bedrooms"]
[null,null,null,null,null,"Fixture 1 \nID",{"$f":"CONCATENATE(\"Fixture 1 \nFlow Rate\n\",IF(UOM=1,\"(gpm)\",\"(lpm)\"))","v":"Fixture 1 \nFlow Rate\n(gpm)"},"Fixture 2\nID",{"$f":"CONCATENATE(\"Fixture 2 \nFlow Rate\n\",IF(UOM=1,\"(gpm)\",\"(lpm)\"))","v":"Fixture 2 \nFlow Rate\n(gpm)"},"Fixture 3\nID",{"$f":"CONCATENATE(\"Fixture 3 \nFlow Rate\n\",IF(UOM=1,\"(gpm)\",\"(lpm)\"))","v":"Fixture 3 \nFlow Rate\n(gpm)"},"Fixture 4\nID",{"$f":"CONCATENATE(\"Fixture 4 \nFlow Rate\n\",IF(UOM=1,\"(gpm)\",\"(lpm)\"))","v":"Fixture 4 \nFlow Rate\n(gpm)"}]
[{"$f":"IF(B52>0,0,0)","v":0},null,null,null,{"$f":"IFERROR(IF(B52=\"All units\",$D$18,(V52+1)*D52),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(F52,$B$44:$C$47,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H52,$B$44:$C$47,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(J52,$B$44:$C$47,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(L52,$B$44:$C$47,2,FALSE),\"\")","v":""},{"$f":"IFERROR(SUM(G52,I52,K52,M52)/COUNTA(F52,H52,J52,L52),\"\")","v":""},{"$f":"IFERROR(N52*$P52,\"\")","v":""},{"$f":"IF(B52<>\"\",$C$135,\"\")","v":""},{"$f":"IF(B52<>\"\",IF(UOM=1,$F$135,$H$135),\"\")","v":""},{"$f":"IF(B52<>\"\",IF(UOM=1,$J$135,$K$135),\"\")","v":""},{"$f":"IFERROR(O52*30*$E52,\"\")","v":""},{"$f":"IFERROR(R52*30*$E52,\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B52,$B$11:$V$17,21,FALSE),\"\")","v":""}]
[{"$f":"IF(B53>0,0,0)","v":0},null,null,null,{"$f":"IFERROR(IF(B53=\"All units\",$D$18,(V53+1)*D53),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(F53,$B$44:$C$47,2,FALSE),\"\")","v":""},null,"",null,{"$f":"IFERROR(VLOOKUP(J53,$B$44:$C$47,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(L53,$B$44:$C$47,2,FALSE),\"\")","v":""},{"$f":"IFERROR(SUM(G53,I53,K53,M53)/COUNTA(F53,H53,J53,L53),\"\")","v":""},{"$f":"IFERROR(N53*$P53,\"\")","v":""},{"$f":"IF(B53<>\"\",$C$135,\"\")","v":""},{"$f":"IF(B53<>\"\",IF(UOM=1,$F$135,$H$135),\"\")","v":""},{"$f":"IF(B53<>\"\",IF(UOM=1,$J$135,$K$135),\"\")","v":""},{"$f":"IFERROR(O53*30*$E53,\"\")","v":""},{"$f":"IFERROR(R53*30*$E53,\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B53,$B$11:$V$17,21,FALSE),\"\")","v":""}]
[{"$f":"IF(B54>0,0,0)","v":0},null,null,null,{"$f":"IFERROR(IF(B54=\"All units\",$D$18,(V54+1)*D54),0)","v":0},null,"",null,"",null,"",null,"","",{"$f":"IFERROR(N54*$P54,\"\")","v":""},{"$f":"IF(B54<>\"\",$C$135,\"\")","v":""},{"$f":"IF(B54<>\"\",IF(UOM=1,$F$135,$H$135),\"\")","v":""},{"$f":"IF(B54<>\"\",IF(UOM=1,$J$135,$K$135),\"\")","v":""},{"$f":"IFERROR(O54*30*$E54,\"\")","v":""},{"$f":"IFERROR(R54*30*$E54,\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B54,$B$11:$V$17,21,FALSE),\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(B55=\"All units\",$D$18,(V55+1)*D55),0)","v":0},null,"",null,"",null,"",null,"","",{"$f":"IFERROR(N55*$P55,\"\")","v":""},{"$f":"IF(B55<>\"\",$C$135,\"\")","v":""},{"$f":"IF(B55<>\"\",IF(UOM=1,$F$135,$H$135),\"\")","v":""},{"$f":"IF(B55<>\"\",IF(UOM=1,$J$135,$K$135),\"\")","v":""},{"$f":"IFERROR(O55*30*$E55,\"\")","v":""},{"$f":"IFERROR(R55*30*$E55,\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B55,$B$11:$V$17,21,FALSE),\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(B56=\"All units\",$D$18,(V56+1)*D56),0)","v":0},null,"",null,"",null,"",null,"","",{"$f":"IFERROR(N56*$P56,\"\")","v":""},{"$f":"IF(B56<>\"\",$C$135,\"\")","v":""},{"$f":"IF(B56<>\"\",IF(UOM=1,$F$135,$H$135),\"\")","v":""},{"$f":"IF(B56<>\"\",IF(UOM=1,$J$135,$K$135),\"\")","v":""},{"$f":"IFERROR(O56*30*$E56,\"\")","v":""},{"$f":"IFERROR(R56*30*$E56,\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B56,$B$11:$V$17,21,FALSE),\"\")","v":""}]
["C","Totals for lavs and kitchen faucets",null,{"$f":"SUM(D52:D56)","v":0},{"$f":"SUM(E52:E56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S52:S56)","v":0},{"$f":"SUM(T52:T56)","v":0}]
[]
[]
[null,"Fixture Use for Toilets"]
[]
[null,"For projects with dual-flush toilets\nCalculate the average flush rate below and enter the resulting flush rate into the design case flush rate section for toilet."]
[null,{"$f":"CONCATENATE(\"High flush rate\",IF(UOM=1,\" (gpf)\",\" (lpf)\"))","v":"High flush rate (gpf)"}]
[null,{"$f":"CONCATENATE(\"Low flush rate\",IF(UOM=1,\" (gpf)\",\" (lpf)\"))","v":"Low flush rate (gpf)"}]
[null,{"$f":"CONCATENATE(\"Average flush rate\",IF(UOM=1,\" (gpf)\",\" (lpf)\"))","v":"Average flush rate (gpf)"},null,null,{"$f":"IFERROR((2*E64+E63)/3,0)","v":0}]
[]
[null,"Fixture ID",{"$f":"CONCATENATE(\"Flush Rate\n\",IF(UOM=1,\"(gpf)\",\"(lpf)\"))","v":"Flush Rate\n(gpf)"}]
[{"$f":"IF(B68>0,0,0)","v":0}]
[{"$f":"IF(B69>0,0,0)","v":0}]
[{"$f":"IF(B70>0,0,0)","v":0}]
[]
[]
[null,"Unit Information",null,null,null,"Design",null,null,null,null,null,null,null,null,null,"Baseline",null,null,"Totals"]
[null,"Unit Type","Unit \nDescription","Number of \nUnits","Occupants","Fixture 1",null,"Fixture 2",null,"Fixture 3",null,"Fixture 4",null,{"$f":"CONCATENATE(\"Average\nFlush Rate\n\",IF(UOM=1,\"(gpf)\",\"(lpf)\"))","v":"Average\nFlush Rate\n(gpf)"},{"$f":"CONCATENATE(\"Calculated\nWater Usage\n\",IF(UOM=1,\" (gallons)\",\" (liters)\"))","v":"Calculated\nWater Usage\n (gallons)"},"Estimated Fixture Usage\n(flushes)",{"$f":"CONCATENATE(\"Flush Rate\n\",IF(UOM=1,\"(gpf)\",\"(lpf)\"))","v":"Flush Rate\n(gpf)"},{"$f":"CONCATENATE(\"Estimated\nWater Usage\n\",IF(UOM=1,\" (gallons)\",\" (liters)\"))","v":"Estimated\nWater Usage\n (gallons)"},{"$f":"CONCATENATE(\"Design\nMonthly \nWater Use\n\",IF(UOM=1,\" (gal/month)\",\" (l/month)\"))","v":"Design\nMonthly \nWater Use\n (gal/month)"},{"$f":"CONCATENATE(\"Baseline Monthly \nWater Use\n\",IF(UOM=1,\" (gal/month)\",\" (l/month)\"))","v":"Baseline Monthly \nWater Use\n (gal/month)"},null,"Number of Bedrooms"]
[null,null,null,null,null,"Fixture 1 \nID",{"$f":"CONCATENATE(\"Fixture 1\nFlush Rate\n\",IF(UOM=1,\"(gpf)\",\"(lpf)\"))","v":"Fixture 1\nFlush Rate\n(gpf)"},"Fixture 2\nID",{"$f":"CONCATENATE(\"Fixture 2\nFlush Rate\n\",IF(UOM=1,\"(gpf)\",\"(lpf)\"))","v":"Fixture 2\nFlush Rate\n(gpf)"},"Fixture 3\nID",{"$f":"CONCATENATE(\"Fixture 3\nFlush Rate\n\",IF(UOM=1,\"(gpf)\",\"(lpf)\"))","v":"Fixture 3\nFlush Rate\n(gpf)"},"Fixture 4\nID",{"$f":"CONCATENATE(\"Fixture 4\nFlush Rate\n\",IF(UOM=1,\"(gpf)\",\"(lpf)\"))","v":"Fixture 4\nFlush Rate\n(gpf)"}]
[{"$f":"IF(B76>0,0,0)","v":0},null,null,null,{"$f":"IFERROR(IF(B76=\"All units\",$D$18,(V76+1)*D76),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(F76,$B$68:$C$71,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H76,$B$68:$C$71,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(J76,$B$68:$C$71,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(L76,$B$68:$C$71,2,FALSE),\"\")","v":""},{"$f":"IFERROR(SUM(G76,I76,K76,M76)/COUNTA(F76,H76,J76,L76),\"\")","v":""},{"$f":"IFERROR(N76*$P76,\"\")","v":""},{"$f":"IF(B76<>\"\",$C$136,\"\")","v":""},{"$f":"IF(B76<>\"\",IF(UOM=1,$F$136,$H$136),\"\")","v":""},{"$f":"IF(B76<>\"\",IF(UOM=1,$J$136,$K$136),\"\")","v":""},{"$f":"IFERROR(O76*30*$E76,\"\")","v":""},{"$f":"IFERROR(R76*30*$E76,\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B76,$B$11:$V$17,21,FALSE),\"\")","v":""}]
[{"$f":"IF(B77>0,0,0)","v":0},null,null,null,{"$f":"IFERROR(IF(B77=\"All units\",$D$18,(V77+1)*D77),0)","v":0},null,"",null,"",null,{"$f":"IFERROR(VLOOKUP(J77,$B$68:$C$71,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(L77,$B$68:$C$71,2,FALSE),\"\")","v":""},{"$f":"IFERROR(SUM(G77,I77,K77,M77)/COUNTA(F77,H77,J77,L77),\"\")","v":""},{"$f":"IFERROR(N77*$P77,\"\")","v":""},{"$f":"IF(B77<>\"\",$C$136,\"\")","v":""},{"$f":"IF(B77<>\"\",IF(UOM=1,$F$136,$H$136),\"\")","v":""},{"$f":"IF(B77<>\"\",IF(UOM=1,$J$136,$K$136),\"\")","v":""},{"$f":"IFERROR(O77*30*$E77,\"\")","v":""},{"$f":"IFERROR(R77*30*$E77,\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B77,$B$11:$V$17,21,FALSE),\"\")","v":""}]
[{"$f":"IF(B78>0,0,0)","v":0},null,null,null,{"$f":"IFERROR(IF(B78=\"All units\",$D$18,(V78+1)*D78),0)","v":0},null,"",null,"",null,"",null,"","",{"$f":"IFERROR(N78*$P78,\"\")","v":""},{"$f":"IF(B78<>\"\",$C$136,\"\")","v":""},{"$f":"IF(B78<>\"\",IF(UOM=1,$F$136,$H$136),\"\")","v":""},{"$f":"IF(B78<>\"\",IF(UOM=1,$J$136,$K$136),\"\")","v":""},{"$f":"IFERROR(O78*30*$E78,\"\")","v":""},{"$f":"IFERROR(R78*30*$E78,\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B78,$B$11:$V$17,21,FALSE),\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(B79=\"All units\",$D$18,(V79+1)*D79),0)","v":0},null,"",null,"",null,"",null,"","",{"$f":"IFERROR(N79*$P79,\"\")","v":""},{"$f":"IF(B79<>\"\",$C$136,\"\")","v":""},{"$f":"IF(B79<>\"\",IF(UOM=1,$F$136,$H$136),\"\")","v":""},{"$f":"IF(B79<>\"\",IF(UOM=1,$J$136,$K$136),\"\")","v":""},{"$f":"IFERROR(O79*30*$E79,\"\")","v":""},{"$f":"IFERROR(R79*30*$E79,\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B79,$B$11:$V$17,21,FALSE),\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(B80=\"All units\",$D$18,(V80+1)*D80),0)","v":0},null,"",null,"",null,"",null,"","",{"$f":"IFERROR(N80*$P80,\"\")","v":""},{"$f":"IF(B80<>\"\",$C$136,\"\")","v":""},{"$f":"IF(B80<>\"\",IF(UOM=1,$F$136,$H$136),\"\")","v":""},{"$f":"IF(B80<>\"\",IF(UOM=1,$J$136,$K$136),\"\")","v":""},{"$f":"IFERROR(O80*30*$E80,\"\")","v":""},{"$f":"IFERROR(R80*30*$E80,\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B80,$B$11:$V$17,21,FALSE),\"\")","v":""}]
["D","Totals for toilets",null,{"$f":"SUM(D76:D80)","v":0},{"$f":"SUM(E76:E80)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S76:S80)","v":0},{"$f":"SUM(T76:T80)","v":0}]
[]
[]
[null,"Fixture Use for Clothes Washers"]
[null,"Enter the flow rate and a brief description for each type of fixture.  If no clothes washer is installed in the project, enter 'Baseline' under 'Fixture ID' and '9.5' under 'Flow Rate.'"]
[null,"Fixture ID","Flow Rate\n(water factor)"]
[{"$f":"IF(B87>0,0,0)","v":0}]
[{"$f":"IF(B88>0,0,0)","v":0}]
[{"$f":"IF(B89>0,0,0)","v":0}]
[]
[]
[null,"Unit Information",null,null,null,"Design",null,null,null,null,null,null,null,null,null,"Baseline",null,null,"Totals"]
[null,"Unit Type","Unit \nDescription","Number of \nUnits","Occupants","Fixture 1",null,"Fixture 2",null,"Fixture 3",null,"Fixture 4",null,"Average \nFlow Rate\n(water factor)",{"$f":"CONCATENATE(\"Calculated\nWater Usage\n\",IF(UOM=1,\" (gallons)\",\" (liters)\"))","v":"Calculated\nWater Usage\n (gallons)"},{"$f":"CONCATENATE(\"Estimated Fixture Usage\n(cycles \",IF(UOM=1,\"at 3.5 cu ft)\",\"at 0.1 cu m)\"))","v":"Estimated Fixture Usage\n(cycles at 3.5 cu ft)"},"Flow Rate\n(water factor)",{"$f":"CONCATENATE(\"Estimated\nWater Usage\n\",IF(UOM=1,\" (gallons)\",\" (liters)\"))","v":"Estimated\nWater Usage\n (gallons)"},{"$f":"CONCATENATE(\"Design\nMonthly \nWater Use\n\",IF(UOM=1,\" (gal/month)\",\" (l/month)\"))","v":"Design\nMonthly \nWater Use\n (gal/month)"},{"$f":"CONCATENATE(\"Baseline\nMonthly \nWater Use\n\",IF(UOM=1,\" (gal/month)\",\" (l/month)\"))","v":"Baseline\nMonthly \nWater Use\n (gal/month)"},null,"Number of Bedrooms"]
[null,null,null,null,null,"Fixture 1 \nID","Fixture 1\nFlow Rate\n(water factor)","Fixture 2\nID","Fixture 2\nFlow Rate\n(water factor)","Fixture 3\nID","Fixture 3\nFlow Rate\n(water factor)","Fixture 4\nID","Fixture 4\nFlow Rate\n(water factor)"]
[{"$f":"IF(B95>0,0,0)","v":0},null,null,null,{"$f":"IFERROR(IF(B95=\"All units\",$D$18,(V95+1)*D95),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(F95,$B$87:$C$90,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H95,$B$87:$C$90,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(J95,$B$87:$C$90,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(L95,$B$87:$C$90,2,FALSE),\"\")","v":""},{"$f":"IFERROR(SUM(G95,I95,K95,M95)/COUNTA(F95,H95,J95,L95),\"\")","v":""},{"$f":"IFERROR(IF(N95=\"\",\"\",IF(UOM=1,(P95*N95*3.5)*1.23,((P95*N95*3.5)*1.23)*3.78)),\"\")","v":""},{"$f":"IF(B95<>\"\",$C$137,\"\")","v":""},{"$f":"IF(B95<>\"\",$F$137,\"\")","v":""},{"$f":"IF(B95<>\"\",IF(UOM=1,$J$137,$K$137),\"\")","v":""},{"$f":"IFERROR(O95*30*$E95,\"\")","v":""},{"$f":"IFERROR(R95*30*$E95,\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B95,$B$11:$V$17,21,FALSE),\"\")","v":""}]
[{"$f":"IF(B96>0,0,0)","v":0},null,null,null,{"$f":"IFERROR(IF(B96=\"All units\",$D$18,(V96+1)*D96),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(F96,$B$87:$C$90,2,FALSE),\"\")","v":""},null,"",null,{"$f":"IFERROR(VLOOKUP(J96,$B$87:$C$90,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(L96,$B$87:$C$90,2,FALSE),\"\")","v":""},{"$f":"IFERROR(SUM(G96,I96,K96,M96)/COUNTA(F96,H96,J96,L96),\"\")","v":""},{"$f":"IFERROR(IF(N96=\"\",\"\",IF(UOM=1,(P96*N96*3.5)*1.23,((P96*N96*3.5)*1.23)*3.78)),\"\")","v":""},{"$f":"IF(B96<>\"\",$C$137,\"\")","v":""},{"$f":"IF(B96<>\"\",$F$137,\"\")","v":""},{"$f":"IF(B96<>\"\",IF(UOM=1,$J$137,$K$137),\"\")","v":""},{"$f":"IFERROR(O96*30*$E96,\"\")","v":""},{"$f":"IFERROR(R96*30*$E96,\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B96,$B$11:$V$17,21,FALSE),\"\")","v":""}]
[{"$f":"IF(B97>0,0,0)","v":0},null,null,null,{"$f":"IFERROR(IF(B97=\"All units\",$D$18,(V97+1)*D97),0)","v":0},null,"",null,"",null,"",null,"","",{"$f":"IFERROR(IF(N97=\"\",\"\",IF(UOM=1,(P97*N97*3.5)*1.23,((P97*N97*3.5)*1.23)*3.78)),\"\")","v":""},{"$f":"IF(B97<>\"\",$C$137,\"\")","v":""},{"$f":"IF(B97<>\"\",$F$137,\"\")","v":""},{"$f":"IF(B97<>\"\",IF(UOM=1,$J$137,$K$137),\"\")","v":""},"","",null,{"$f":"IFERROR(VLOOKUP(B97,$B$11:$V$17,21,FALSE),\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(B98=\"All units\",$D$18,(V98+1)*D98),0)","v":0},null,"",null,"",null,"",null,"","",{"$f":"IFERROR(IF(N98=\"\",\"\",IF(UOM=1,(P98*N98*3.5)*1.23,((P98*N98*3.5)*1.23)*3.78)),\"\")","v":""},{"$f":"IF(B98<>\"\",$C$137,\"\")","v":""},{"$f":"IF(B98<>\"\",$F$137,\"\")","v":""},{"$f":"IF(B98<>\"\",IF(UOM=1,$J$137,$K$137),\"\")","v":""},"","",null,{"$f":"IFERROR(VLOOKUP(B98,$B$11:$V$17,21,FALSE),\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(B99=\"All units\",$D$18,(V99+1)*D99),0)","v":0},null,"",null,"",null,"",null,"","",{"$f":"IFERROR(IF(N99=\"\",\"\",IF(UOM=1,(P99*N99*3.5)*1.23,((P99*N99*3.5)*1.23)*3.78)),\"\")","v":""},{"$f":"IF(B99<>\"\",$C$137,\"\")","v":""},{"$f":"IF(B99<>\"\",$F$137,\"\")","v":""},{"$f":"IF(B99<>\"\",IF(UOM=1,$J$137,$K$137),\"\")","v":""},"","",null,{"$f":"IFERROR(VLOOKUP(B99,$B$11:$V$17,21,FALSE),\"\")","v":""}]
["E","Totals for clothes washers",null,{"$f":"SUM(D95:D99)","v":0},{"$f":"SUM(E95:E99)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S95:S99)","v":0},{"$f":"SUM(T95:T99)","v":0}]
[]
[]
[null,"Fixture Use for Dishwashers"]
[null,{"$f":"CONCATENATE(\"Enter the flow rate and a brief description for each type of fixture. If no dishwasher is installed in the project, enter 'Baseline' under 'Fixture ID', and '\",IF(UOM=1,\"'6.5' under 'Flow Rate'.\",\"3 under 'Flow Rate'.\"))","v":"Enter the flow rate and a brief description for each type of fixture. If no dishwasher is installed in the project, enter 'Baseline' under 'Fixture ID', and ''6.5' under 'Flow Rate'."}]
[null,"Fixture ID",{"$f":"CONCATENATE(\"Flow Rate\n\",IF(UOM=1,\"(gpc)\",\"(lpc)\"))","v":"Flow Rate\n(gpc)"}]
[{"$f":"IF(B106>0,0,0)","v":0}]
[{"$f":"IF(B107>0,0,0)","v":0}]
[{"$f":"IF(B108>0,0,0)","v":0}]
[]
[]
[null,"Unit Information",null,null,null,"Design",null,null,null,null,null,null,null,null,null,"Baseline",null,null,"Totals"]
[null,"Unit Type","Unit \nDescription","Number of \nUnits","Occupants","Fixture 1",null,"Fixture 2",null,"Fixture 3",null,"Fixture 4",null,{"$f":"CONCATENATE(\"Average \nFlow Rate\n\",IF(UOM=1,\"(gpc)\",\"(lpc)\"))","v":"Average \nFlow Rate\n(gpc)"},{"$f":"CONCATENATE(\"Calculated\nWater Usage\n\",IF(UOM=1,\" (gallons)\",\" (liters)\"))","v":"Calculated\nWater Usage\n (gallons)"},"Estimated Fixture Usage\n(cycles)",{"$f":"CONCATENATE(\"Flow Rate\n\",IF(UOM=1,\"(gpc)\",\"(lpc)\"))","v":"Flow Rate\n(gpc)"},{"$f":"CONCATENATE(\"Estimated\nWater Usage\n\",IF(UOM=1,\" (gallons)\",\" (liters)\"))","v":"Estimated\nWater Usage\n (gallons)"},{"$f":"CONCATENATE(\"Design\nMonthly \nWater Use\n\",IF(UOM=1,\" (gal/month)\",\" (l/month)\"))","v":"Design\nMonthly \nWater Use\n (gal/month)"},{"$f":"CONCATENATE(\"Baseline\nMonthly \nWater Use\n\",IF(UOM=1,\" (gal/month)\",\" (l/month)\"))","v":"Baseline\nMonthly \nWater Use\n (gal/month)"},null,"Number of Bedrooms"]
[null,null,null,null,null,"Fixture 1 \nID",{"$f":"CONCATENATE(\"Fixture 1\nFlow Rate\n\",IF(UOM=1,\"(gpc)\",\"(lpc)\"))","v":"Fixture 1\nFlow Rate\n(gpc)"},"Fixture 2\nID",{"$f":"CONCATENATE(\"Fixture 2\nFlow Rate\n\",IF(UOM=1,\"(gpc)\",\"(lpc)\"))","v":"Fixture 2\nFlow Rate\n(gpc)"},"Fixture 3\nID",{"$f":"CONCATENATE(\"Fixture 3\nFlow Rate\n\",IF(UOM=1,\"(gpc)\",\"(lpc)\"))","v":"Fixture 3\nFlow Rate\n(gpc)"},"Fixture 4\nID",{"$f":"CONCATENATE(\"Fixture 4\nFlow Rate\n\",IF(UOM=1,\"(gpc)\",\"(lpc)\"))","v":"Fixture 4\nFlow Rate\n(gpc)"}]
[{"$f":"IF(B114>0,0,0)","v":0},null,null,null,{"$f":"IFERROR(IF(B114=\"All units\",$D$18,(V114+1)*D114),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(F114,$B$106:$C$109,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H114,$B$106:$C$109,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(J114,$B$106:$C$109,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(L114,$B$106:$C$109,2,FALSE),\"\")","v":""},{"$f":"IFERROR(SUM(G114,I114,K114,M114)/COUNTA(F114,H114,J114,L114),\"\")","v":""},{"$f":"IFERROR(N114*$P114,\"\")","v":""},{"$f":"IF(B114<>\"\",$C$138,\"\")","v":""},{"$f":"IF(B114<>\"\",IF(UOM=1,$F$138,$H$138),\"\")","v":""},{"$f":"IF(B114<>\"\",IF(UOM=1,$J$138,$K$138),\"\")","v":""},{"$f":"IFERROR(O114*30*$E114,\"\")","v":""},{"$f":"IFERROR(R114*30*$E114,\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B114,$B$11:$V$17,21,FALSE),\"\")","v":""}]
[{"$f":"IF(B115>0,0,0)","v":0},null,null,null,{"$f":"IFERROR(IF(B115=\"All units\",$D$18,(V115+1)*D115),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(F115,$B$106:$C$109,2,FALSE),\"\")","v":""},null,"",null,{"$f":"IFERROR(VLOOKUP(J115,$B$106:$C$109,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(L115,$B$106:$C$109,2,FALSE),\"\")","v":""},{"$f":"IFERROR(SUM(G115,I115,K115,M115)/COUNTA(F115,H115,J115,L115),\"\")","v":""},{"$f":"IFERROR(N115*$P115,\"\")","v":""},{"$f":"IF(B115<>\"\",$C$138,\"\")","v":""},{"$f":"IF(B115<>\"\",IF(UOM=1,$F$138,$H$138),\"\")","v":""},{"$f":"IF(B115<>\"\",IF(UOM=1,$J$138,$K$138),\"\")","v":""},{"$f":"IFERROR(O115*30*$E115,\"\")","v":""},{"$f":"IFERROR(R115*30*$E115,\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B115,$B$11:$V$17,21,FALSE),\"\")","v":""}]
[{"$f":"IF(B116>0,0,0)","v":0},null,null,null,{"$f":"IFERROR(IF(B116=\"All units\",$D$18,(V116+1)*D116),0)","v":0},null,"",null,"",null,"",null,"","",{"$f":"IFERROR(N116*$P116,\"\")","v":""},{"$f":"IF(B116<>\"\",$C$138,\"\")","v":""},{"$f":"IF(B116<>\"\",IF(UOM=1,$F$138,$H$138),\"\")","v":""},{"$f":"IF(B116<>\"\",IF(UOM=1,$J$138,$K$138),\"\")","v":""},"","",null,{"$f":"IFERROR(VLOOKUP(B116,$B$11:$V$17,21,FALSE),\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(B117=\"All units\",$D$18,(V117+1)*D117),0)","v":0},null,"",null,"",null,"",null,"","",{"$f":"IFERROR(N117*$P117,\"\")","v":""},{"$f":"IF(B117<>\"\",$C$138,\"\")","v":""},{"$f":"IF(B117<>\"\",IF(UOM=1,$F$138,$H$138),\"\")","v":""},{"$f":"IF(B117<>\"\",IF(UOM=1,$J$138,$K$138),\"\")","v":""},"","",null,{"$f":"IFERROR(VLOOKUP(B117,$B$11:$V$17,21,FALSE),\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(B118=\"All units\",$D$18,(V118+1)*D118),0)","v":0},null,"",null,"",null,"",null,"","",{"$f":"IFERROR(N118*$P118,\"\")","v":""},{"$f":"IF(B118<>\"\",$C$138,\"\")","v":""},{"$f":"IF(B118<>\"\",IF(UOM=1,$F$138,$H$138),\"\")","v":""},{"$f":"IF(B118<>\"\",IF(UOM=1,$J$138,$K$138),\"\")","v":""},"","",null,{"$f":"IFERROR(VLOOKUP(B118,$B$11:$V$17,21,FALSE),\"\")","v":""}]
["F","Totals for dishwashers",null,{"$f":"SUM(D114:D118)","v":0},{"$f":"SUM(E114:E118)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S114:S118)","v":0},{"$f":"SUM(T114:T118)","v":0}]
[]
[]
[null,"Indoor Water Use Summary"]
[null,"Fixture Type",null,null,null,null,{"$f":"CONCATENATE(\"Design\nWater Use\n\",IF(UOM=1,\" (gal/month)\",\" (l/month)\"))","v":"Design\nWater Use\n (gal/month)"},{"$f":"CONCATENATE(\"Baseline\nWater Use\n\",IF(UOM=1,\" (gal/month)\",\" (l/month)\"))","v":"Baseline\nWater Use\n (gal/month)"},{"$f":"CONCATENATE(\"Savings\n\",IF(UOM=1,\" (gal/month)\",\" (l/month)\"))","v":"Savings\n (gal/month)"}]
[null,"Showers",null,null,null,null,{"$f":"S39","v":0},{"$f":"T39","v":0},{"$f":"IF(G124=0,0,H124-G124)","v":0}]
[null,"Lavatories and kitchen faucets",null,null,null,null,{"$f":"S57","v":0},{"$f":"T57","v":0},{"$f":"IF(G125=0,0,H125-G125)","v":0}]
[null,"Toilets",null,null,null,null,{"$f":"S81","v":0},{"$f":"T81","v":0},{"$f":"IF(G126=0,0,H126-G126)","v":0}]
[null,"Clothes washers",null,null,null,null,{"$f":"S100","v":0},{"$f":"T100","v":0},{"$f":"IF(G127=0,0,H127-G127)","v":0}]
[null,"Dishwashers",null,null,null,null,{"$f":"S119","v":0},{"$f":"T119","v":0},{"$f":"IF(G128=0,0,H128-G128)","v":0}]
[null,"Totals",null,null,null,null,{"$f":"SUM(G124:G128)","v":0},{"$f":"SUM(H124:H128)","v":0},{"$f":"SUM(I124:I128)","v":0}]
[]
[null,"Assumptions"]
[null,"Fixture","Estimated \nFixture Usage",null,null,"Baseline \nFlush or Flow Rate",null,null,null,"Estimated \nWater Usage"]
[null,null,null,null,null,"IP",null,"SI",null,"IP\n(gallons per person)","SI\n(liters per person)"]
[null,"Shower",{"$f":"8.2*0.75","v":6.15},"minutes",null,2.5,"gpm",9.5,"lpm",{"$f":"F134*C134","v":15.4},{"$f":"H134*C134","v":58.4}]
[null,"Lavatory or kitchen faucet",5,"minutes",null,2.2000000000000002,"gpm",8.3000000000000007,"lpm",{"$f":"F135*C135","v":11},{"$f":"H135*C135","v":41.5}]
[null,"Toilet",5.05,"flushes",null,1.6,"gpf",6,"lpf",{"$f":"F136*C136","v":8.1},{"$f":"H136*C136","v":30.3}]
[null,"Clothes washer",0.37,"at 3.5 cu ft (0.1 cu m)",null,9.5,"WF",9.5,"WF",{"$f":"(C137*F137*3.5)*1.23","v":15.1},{"$f":"((C137*F137*3.5)*1.23)*3.78","v":57.2}]
[null,"Dishwasher",0.1,"cycles",null,6.5,"gpc",24,"lpc",{"$f":"F138*C138","v":0.7},{"$f":"H138*C138","v":2.4}]

{"sheet":"Summary D+C","index":5,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[7,4,7,6],[8,4,8,6],[7,3,9,3],[8,7,8,9],[7,7,7,9]]}
[]
[null,null,1]
[null,null,1,"Summary for Design and Construction Rating Systems"]
[null,null,1,"Note: All information on this tab is READ-ONLY. To edit, see the previous tab(s). "]
[null,null,1]
[null,null,1]
[null,null,1]
[null,null,1,"Group Name","Baseline Case",null,null,"Design Case"]
[null,null,null,null,{"$f":"IF(Instructions!T57=1,\"(gallons/year)\",\"(liters/year)\")","v":"(gallons/year)"},null,null,{"$f":"IF(Instructions!T57=1,\"(gallons/year)\",\"(liters/year)\")","v":"(gallons/year)"}]
[null,null,1,null,"Annual \nFlush \nVolume","Annual \nFlow \nVolume","Annual\nConsumption","Annual \nFlush \nVolume","Annual \nFlow \nVolume","Annual \nConsumption"]
[null,null,{"$f":"IF(OR(D11=\"Instructions\",D11=\"Base Calc\",D11=\"Lowrise Indoor Water Use\",D11=\"Lowrise Wastewater Use\",D11=\"Summary D+C\",D11=\"Summary O+M\",D11=\"Summary ND\",D11=\"\",D11=0),0,1)","v":1},{"$f":"IFERROR(INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROW(A2),1),\"\")","v":"Group 1"},{"$f":"INDIRECT(\"'\"&D11&\"'!$Z$12\")","v":0},{"$f":"INDIRECT(\"'\"&$D11&\"'!$Z$11\")","v":0},{"$f":"E11+F11","v":0},{"$f":"INDIRECT(\"'\"&$D11&\"'!$Z$14\")","v":0},{"$f":"INDIRECT(\"'\"&$D11&\"'!$Z$13\")","v":0},{"$f":"H11+I11","v":0}]
[null,null,1]
[null,"A",1,{"$f":"IF(Instructions!T57=1,\"Annual baseline water consumption (gallons/year)\",\"Annual baseline water consumption (liters/year)\")","v":"Annual baseline water consumption (gallons/year)"},null,null,null,null,null,{"$f":"SUM(G11:G12)","v":0}]
[null,null,1,{"$f":"IF(Instructions!T57=1,\"Annual design water consumption (gallons/year)\",\"Annual design water consumption (liters/year)\")","v":"Annual design water consumption (gallons/year)"},null,null,null,null,null,{"$f":"SUM(J11:J12)","v":0}]
[null,null,1,"Percent water use reduction (%)",null,null,null,null,null,{"$f":"IF(J14=0,0,(J13-J14)/J13)","v":0}]
[null,null,1]
[]
[]
[]
[null,null,null,null,null,{"$f":"IFERROR(INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROW(#REF!),1),\"\")","v":""}]

{"sheet":"Summary O+M","index":6,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":false,"merged":[[13,3,15,3],[13,4,13,6],[13,7,13,9],[14,4,14,6],[14,7,14,9]]}
[]
[null,null,1]
[null,null,1,"Summary for Operations and Maintenance Rating Systems"]
[null,null,1,"Note: Baseline and design volumes are READ-ONLY. To edit, see the previous tab(s). "]
[null,null,1]
[null,null,1]
[null,null,1,"Unrenovated percentage of fixtures installed before 1995 (%)"]
[null,null,1]
[null,null,1,"Renovated percentage of fixtures installed in 1995 or later (%)"]
[null,null,1]
[null,null,1]
[null,null,1]
[null,null,1]
[null,null,1,"Group Name","Baseline Case",null,null,"Design Case"]
[null,null,null,null,{"$f":"IF(Instructions!T57=1,\"(gallons/year)\",\"(liters/year)\")","v":"(gallons/year)"},null,null,{"$f":"IF(Instructions!T57=1,\"(gallons/year)\",\"(liters/year)\")","v":"(gallons/year)"}]
[null,null,1,null,"Annual \nFlush \nVolume","Annual \nFlow \nVolume","Annual\nConsumption","Annual \nFlush \nVolume","Annual \nFlow \nVolume","Annual\nConsumption"]
[null,null,{"$f":"IF(OR(D17=\"Instructions\",D17=\"Base Calc\",D17=\"Lowrise Indoor Water Use\",D17=\"Lowrise Wastewater Use\",D17=\"Summary D+C\",D17=\"Summary O+M\",D17=\"Summary ND\",D17=\"\",D17=0),0,1)","v":1},{"$f":"IFERROR(INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROW(A2),1),\"\")","v":"Group 1"},{"$f":"INDIRECT(\"'\"&D17&\"'!$Z$12\")","v":0},{"$f":"INDIRECT(\"'\"&$D17&\"'!$Z$11\")","v":0},{"$f":"E17+F17","v":0},{"$f":"INDIRECT(\"'\"&$D17&\"'!$Z$14\")","v":0},{"$f":"INDIRECT(\"'\"&$D17&\"'!$Z$13\")","v":0},{"$f":"H17+I17","v":0}]
[null,null,1]
[null,"A",1,{"$f":"IF(Instructions!T57=1,\"Annual baseline water consumption (gallons/year)\",\"Annual baseline water consumption (liters/year)\")","v":"Annual baseline water consumption (gallons/year)"},null,null,null,null,null,{"$f":"SUM(G17:G18)","v":0}]
[null,null,1,{"$f":"IF(Instructions!T57=1,\"Annual design water consumption (gallons/year)\",\"Annual design water consumption (liters/year)\")","v":"Annual design water consumption (gallons/year)"},null,null,null,null,null,{"$f":"SUM(J17:J18)","v":0}]
[null,null,1,"Baseline multiplier (%)",null,null,null,null,null,{"$f":"((G7*150%)+(G9*120%))","v":0}]
[null,null,1,{"$f":"IF(Instructions!T57=1,\"Water consumption maximum (gallons/year)\",\"Water consumption maximum (liters/year)\")","v":"Water consumption maximum (gallons/year)"},null,null,null,null,null,{"$f":"J19*J21","v":0}]
[null,null,1,"Percentage below water consumption maximum (%)",null,null,null,null,null,{"$f":"IF(J22=0,0,(J22-J20)/J22)","v":0}]
[null,null,1]
[]
[]
[]
[null,null,null,null,null,{"$f":"IFERROR(INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROW(#REF!),1),\"\")","v":""}]

{"sheet":"Summary ND","index":7,"n_rows":45,"n_cols":10,"rows_kept":45,"cut":false,"hidden":true,"merged":[[42,3,43,8],[12,3,14,3],[12,4,12,6],[12,7,12,9],[13,4,13,6],[13,7,13,9]]}
[]
[null,null,1]
[null,null,1,"Summary for Neighborhood Development Rating Systems"]
[null,null,1,"Note: All information on this tab is READ-ONLY. To edit, see the previous tab(s). "]
[null,null,1]
[null,null,1]
[null,null,1,"GIB Prerequisite/Credit Indoor Water Use Reduction"]
[null,null,1]
[null,null,1,"Nonresidential buildings, mixed-use buildings, and multifamily residential buildings four stories or more"]
[null,null,1]
[null,null,1]
[null,null,1]
[null,null,1,"Group Name","Baseline Case",null,null,"Design Case"]
[null,null,null,null,{"$f":"IF(Instructions!T57=1,\"(gallons/year)\",\"(liters/year)\")","v":"(gallons/year)"},null,null,{"$f":"IF(Instructions!T57=1,\"(gallons/year)\",\"(liters/year)\")","v":"(gallons/year)"}]
[null,null,1,null,"Annual \nFlush \nVolume","Annual \nFlow \nVolume","Annual\nConsumption","Annual \nFlush \nVolume","Annual \nFlow \nVolume","Annual \nConsumption"]
[null,null,{"$f":"IF(OR(D16=\"Instructions\",D16=\"Base Calc\",D16=\"Lowrise Indoor Water Use\",D16=\"Lowrise Wastewater Use\",D16=\"Summary D+C\",D16=\"Summary O+M\",D16=\"Summary ND\",D16=\"\",D16=0),0,1)","v":1},{"$f":"IFERROR(INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROW(A2),1),\"\")","v":"Group 1"},{"$f":"INDIRECT(\"'\"&D16&\"'!$Z$12\")","v":0},{"$f":"INDIRECT(\"'\"&$D16&\"'!$Z$11\")","v":0},{"$f":"E16+F16","v":0},{"$f":"INDIRECT(\"'\"&$D16&\"'!$Z$14\")","v":0},{"$f":"INDIRECT(\"'\"&$D16&\"'!$Z$13\")","v":0},{"$f":"H16+I16","v":0}]
[null,null,1]
[null,"A",1,{"$f":"IF(Instructions!T57=1,\"Annual baseline water consumption (gallons/year)\",\"Annual baseline water consumption (liters/year)\")","v":"Annual baseline water consumption (gallons/year)"},null,null,null,null,null,{"$f":"SUM(G16:G17)","v":0}]
[null,null,1,{"$f":"IF(Instructions!T57=1,\"Annual design water consumption (gallons/year)\",\"Annual design water consumption (liters/year)\")","v":"Annual design water consumption (gallons/year)"},null,null,null,null,null,{"$f":"SUM(J16:J17)","v":0}]
[null,null,1,"Percent water use reduction for nonresidential and midrise buildings (%)",null,null,null,null,null,{"$f":"IF(J19=0,0,(J18-J19)/J18)","v":0}]
[null,null,1]
[null,null,1]
[null,null,1,"New single-family residential buildings and new multiunit residential buildings three stories or fewer"]
[null,null,1]
[null,null,1,"Total number of new single-family residential buildings and new multiunit residential buildings three stories or fewer",null,null,null,null,null,{"$f":"'Lowrise Indoor Water Use'!N14","v":0}]
[null,null,1]
[null,null,1,"Total number of residential buildings that would earn at least 2 points under LEED v4 for Homes WE Credit Indoor Water Use",null,null,null,null,null,{"$f":"'Lowrise Indoor Water Use'!N15","v":0}]
[null,null,1]
[null,null,1,"Percentage of new residential buildings that would earn at least 2 points under LEED v4 for Homes WE Credit Indoor Water Use (%)",null,null,null,null,null,{"$f":"IFERROR(J27/J25,0)","v":0}]
[null,null,1]
[null,null,1]
[null,null,1,"For projects pursuing GIB Credit Indoor Water Use Reduction"]
[null,null,1]
[null,null,1,"Total number of residential buildings that would earn at least 4 points under LEED v4 for Homes WE Credit Indoor Water Use",null,null,null,null,null,{"$f":"'Lowrise Indoor Water Use'!N16","v":0}]
[null,null,1]
[null,null,1,"Percentage of new residential buildings that would earn at least 4 points under LEED v4 for Homes WE Credit Indoor Water Use (%)",null,null,null,null,null,{"$f":"IFERROR(J34/J25,0)","v":0}]
[null,null,1]
[null,null,1]
[null,null,1,"GIB Credit Wastewater Management"]
[null,null,1,null,null,{"$f":"IFERROR(INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROW(#REF!),1),\"\")","v":""}]
[null,null,1,{"$f":"CONCATENATE(\"Annual wastewater flow for nonresidential buildings and multiunit residential buildings four stories or more \",IF(UOM=1,\"(gallons/year)\",\"(liters/year)\"))","v":"Annual wastewater flow for nonresidential buildings and multiunit residential buildings four stories or more (gallons/year)"},null,null,null,null,null,{"$f":"J19","v":0}]
[null,null,1]
[null,null,1,{"$f":"CONCATENATE(\"Annual wastewater flow for single-family residential buildings and multiunit residential buildings three stories or fewer \",IF(UOM=1,\"(gallons/year)\",\"(liters/year)\"))","v":"Annual wastewater flow for single-family residential buildings and multiunit residential buildings three stories or fewer (gallons/year)"},null,null,null,null,null,{"$f":"'Lowrise Wastewater Use'!G129","v":0}]
[]
[null,null,1]